Received: from gw.heart.com.au (mail.hcs.com.au [203.12.235.237]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4B2bMA68969 for ; Thu, 10 May 2001 22:37:22 -0400 (EDT) (envelope-from keith@heart.com.au) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gw.heart.com.au (8.9.3/8.9.3) with ESMTP id NAA17379; Fri, 11 May 2001 13:02:28 +1000 Received: from heart.com.au ([192.168.0.65]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id MAA07134; Fri, 11 May 2001 12:37:14 +1000 Message-ID: <3AFB512B.50E9951B@heart.com.au> Date: Fri, 11 May 2001 12:40:43 +1000 From: Keith Gray X-Mailer: Mozilla 4.74 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: PostgreSQL Subject: Re: Escape Quotes References: <3AFB3C52.315C48F0@heart.com.au> <11049.989548443@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/85 X-Sequence-Number: 2886 Tom Lane wrote: > > Keith Gray writes: > > Is it possible to get/configure PostgreSQL to handle > > as 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