Horton

Re: [GENERAL] ' syntax

Brett W. McCoy <bmccoy@lan2wan.com>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@lan2wan.com>
To: amarof <amarof@marwan.ac.ma>
Cc: pgsql-general@postgreSQL.org
Date: 1999-06-01T18:24:34Z
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