Skip site navigation (1) Skip section navigation (2)

Re: escape

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: escape
Date: 2010-06-27 12:08:05
Message-ID: i07ev5$1j1$1@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-novice
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.
             
 E'O\'CONNOR'




In response to

  • escape at 2010-06-26 21:21:59 from Jean-Yves F. Barbier

Responses

  • Re: escape at 2010-06-27 14:23:31 from Jean-Yves F. Barbier

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2010-06-27 14:23:31
Subject: Re: escape
Previous:From: Michael WoodDate: 2010-06-26 23:38:38
Subject: Re: Disable autostart on Mac?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group