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
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.
In response to
pgsql-general by date
|Next:||From: Oliver Elphick||Date: 2000-03-07 10:12:07|
|Subject: Re: [GENERAL] FOREIGN KEY syntax |
|Previous:||From: Howie||Date: 2000-03-07 08:39:19|
|Subject: Re: [GENERAL] 50 MB Table|