Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id UAA46511
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 24 Feb 2000 20:04:11 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id UAA23721;
	Thu, 24 Feb 2000 20:03:37 -0500 (EST)
To: Tim Kane <timk@hotgames.com>
cc: PSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] arrays of varchar and " 
In-reply-to: <38B5C4AA.A84809F2@hotgames.com> 
References: <38B5C4AA.A84809F2@hotgames.com>
Comments: In-reply-to Tim Kane <timk@hotgames.com>
	message dated "Fri, 25 Feb 2000 10:54:18 +1100"
Date: Thu, 24 Feb 2000 20:03:37 -0500
Message-ID: <23718.951440617@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Tim Kane <timk@hotgames.com> writes:
> I want to insert a number of array elements here...
>     insert into my_table values ('{"value 1", "value 2", "value 3"}');
> Fine.
> What do I do however, when I want to insert an array element that
> contains a " character?

Hmm.  It looks like array_in tries to deal with backslashed quotes in
array elements; not sure why it's not working exactly.  Will put this
on the "bugs to look at" list.  Expect a fix in 7.0.

			regards, tom lane