Re: escape

On 2010-06-26, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> debian sid
> pg 8.4.4-1
>===============
> Hi list,
>
> I read the docs about escaping, but I can't find any other manner to escape
> than a backslash or to double the single quote:
> SELECT metaphone('O\'CONNOR') or SELECT metaphone('O''CONNOR')
>
> The doc's talking about E, but SELECT metaphone(E'O'CONNOR') fail.

if you use \ as an escape in the string you should use E at the start.

 E'O\'CONNOR'