Le 27 Jun 2010 12:08:05 GMT,
Jasen Betts <jasen(at)xnet(dot)co(dot)nz> a écrit :
> On 2010-06-26, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)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.
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.)
A male mathematician is someone who can count to twenty-one without
unzipping his fly.
In response to
- Re: escape at 2010-06-27 12:08:05 from Jasen Betts
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2010-06-27 14:36:15|
|Subject: view and column rights|
|Previous:||From: Jasen Betts||Date: 2010-06-27 12:08:05|
|Subject: Re: escape|