Le 27 Jun 2010 12:08:05 GMT,
Jasen Betts <jasen@xnet.co.nz> a écrit :
> 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'
Thanks, Jasen (doc wasn't very clear.)
But I also would like to know if there is another way to escape my string
(and especially if there is a builtin or a manner to do that into PG, to
avoid doing that in the program.)
JY
--
A male mathematician is someone who can count to twenty-one without
unzipping his fly.