Re: Escape Quotes

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Escape Quotes
Date: 2001-05-11 02:40:43
Message-ID: 3AFB512B.50E9951B@heart.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
>
> Keith Gray <keith(at)heart(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Keith Gray 2001-05-11 03:17:41 Re: Escape Quotes
Previous Message Tom Lane 2001-05-11 02:38:51 Re: Escape Quotes