Re: Escape Quotes - Mailing list pgsql-sql

From Keith Gray
Subject Re: Escape Quotes
Date
Msg-id 3AFB512B.50E9951B@heart.com.au
Whole thread Raw
In response to Escape Quotes  (Keith Gray <keith@heart.com.au>)
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Escape Quotes
Next
From: Keith Gray
Date:
Subject: Re: Escape Quotes