Gabriel Fernandez <[EMAIL PROTECTED]> writes:
> 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
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 recove
You have to use two backslashes, as the preprocessor will take the first
one out (I may be wrong about this, but I remember reading something
similar a few months ago on this list.) Also, remember that you have to
send two slashes to PostGres, which may mean that you need to use 4 slashes
in
Hi,
I'm using regular expressions in 6.5.3 version but i cannot find the
character to escape special caracters as ?, $, ^.
I've tried with \ but it doesn't works.
Example: i want to find the row with the value 'fisica?' and i do:
select title from libros where title ~* 'fisica\?' ;
but i also