> 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(at)klawitter(dot)de