Re: [GENERAL] ' syntax

From: "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>
To: amarof <amarof(at)marwan(dot)ac(dot)ma>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] ' syntax
Date: 1999-06-01 18:24:34
Message-ID: Pine.BSI.3.91.990601142331.25048D-100000@access1.lan2wan.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 5 Jun 1999, amarof wrote:

> i want to include this character ' in a string like "mystring's" but i
> don't know the right syntax for it.
> when i want to enter a string in the filter condition like "doctorat
> d'etat" , i get this error parse error near etat.

Precede the character with a backslash:

mystring\'s
dotorat d\'etat

Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Chemistry is applied theology.
-- Augustus Stanley Owsley III

In response to

  • ' syntax at 1999-06-05 14:49:49 from amarof

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 1999-06-01 19:01:39 Re: [ADMIN] Re: [SQL] Data recovery
Previous Message The Hermit Hacker 1999-06-01 18:09:15 Re: [GENERAL] RE: [PORTS] AIX-4.2.1 binaries ? more info. PLEASE !