Re: Regular expressions or LIKE ? HELP needed !

> How to escape a "(" ??

select name block where code ~* 'lower\\(';

First, you have to escape the '(' in order to make regexps match the bracket
instead of using it as a grouping operator.

And then you have to escape the escape in order to get it passed to the regexp
system (at least with psql).

> select name from block where code ike '%lower(''%';

Works for me in 7.2.1 (ike should be ilike). Which postgres version are you
running?

With kind regards / mit freundlichem Gruß
    Holger Klawitter
--
Holger Klawitter                          http://www.klawitter.de
lists@klawitter.de