Horton

Re: Escape Quotes

Keith Gray <keith@heart.com.au>

View thread View on postgr.es
From: Keith Gray <keith@heart.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Date: 2001-05-11T02:40:43Z
Lists: pgsql-sql 
Tom Lane wrote:
> 
> Keith Gray <keith@heart.com.au> writes:
> > Is it possible to get/configure PostgreSQL to handle <quote><quote>
> > as <quote> within a dleimited string?
> 
> We already do.
> 
> regression=# select 'O''SHEA';
>  ?column?
> ----------
>  O'SHEA
> (1 row)
> 
>                         regards, tom lane
Sorry,

This may be a problem in "ipgsql" then??
...or is it different in update from select?

Keith