Re: [GENERAL] ' syntax - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: [GENERAL] ' syntax
Date
Msg-id Pine.BSI.3.91.990601142331.25048D-100000@access1.lan2wan.com
Whole thread Raw
In response to ' syntax  (amarof <amarof@marwan.ac.ma>)
Responses Re: [GENERAL] ' syntax  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List 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


pgsql-general by date:

Previous
From: amarof
Date:
Subject: ' syntax
Next
From: John Browning
Date:
Subject: Re: [GENERAL] ' syntax