Received: from mail.etechnologiescorp.com (postfix@[210.8.40.210])
	by hub.org (8.9.3/8.9.3) with ESMTP id CAA38368
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 8 Feb 2000 02:03:32 -0500 (EST)
	(envelope-from timk@hotgames.com)
Received: from hotgames.com (timk.pn.etechnologiescorp.com [192.168.1.125])
	by mail.etechnologiescorp.com (Postfix) with ESMTP id A753F7504A
	for <pgsql-interfaces@postgreSQL.org>;
	Tue,  8 Feb 2000 18:03:01 +1100 (EST)
Message-ID: <389FC07F.137BD592@hotgames.com>
Date: Tue, 08 Feb 2000 18:06:39 +1100
From: Tim Kane <timk@hotgames.com>
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgreSQL.org
Subject: character arrays and quotation
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Is it at all possible to INSERT into an array of string types a value
that contains quotation marks (")?

I've tried escaping the " as \" but it doesn't seem to help...

eg:
    INSERT into my_table VALUES ('{"value_1","value_2","quote\"doesnt
work\" damn","value_4"}');


Any thoughts?

Thanks heaps,

Tim Kane