Use postgresql SIMILAR TO instead of LIKE

Description

The postgresql SIMILAR TO function is fully compatible with LIKE but additionally it supports some regular expressions.

http://www.postgresql.org/docs/8.4/static/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP

With this simple patch:

I was able to make it work.

It would be good to add this to iDempiere? Configurable?

WDYT?

Regards,

Carlos Ruiz

Environment

None

Status

Assignee

Carlos Ruiz

Reporter

Carlos Ruiz

Labels

Tested By

None

Priority

Major
Configure