Re: Help please - completely baffled by quoting

> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e(at)gmx(dot)net]
> Sent: 20 June 2004 14:07
> To: Tim Robinson; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Help please - completely baffled by quoting
>
>
> Tim Robinson wrote:
> > select * from temp where a like 'a\\\'%'
> >
> > this should return all strings starting with a\' but it returns
> > nothing!!!
>
> \ is also the quoting character of LIKE, in addition to being
> a quoting
> character on the string literal level. If you want all strings
> starting with a\' then use something like:
>
> a LIKE 'a\\\'%' ESCAPE '!'
>
> where '!' selects some other escape character for LIKE that
> doesn't get
> in the way. The documentation on LIKE contains the details on this
> mechanism.
>

or..
a LIKE 'a\\\\\'%'

thanks, I get it now :)

--- Tim