Re: Re: [GENERAL] Regular expressions syntax: is \ the escape character ?

Thanks a million to you all. Finally, as someone in the list suggested, i'm
using the double backslash (\\) and it seems it works ok.

The only problem i have is when i want to escape a single quote (') or the
backslash (\).

For example: i have one row with the value 'ONE\SECOND'

I try to recover it doing (from psql frontend):

select field1 from table1 where field1 ~* 'ONE\\\'  ;

But it doesn't work, and the parser seems to be confused (it asks me to
close again the quote ' ).

The problem is the same with the single quote '. I've tried this:

select field1 from table1 where field1 ~* 'D\\'ALEMA' ;

But it doesn't work neither.

Thanks for your help.

Gabi :-)