Received: from mail.etechnologiescorp.com (postfix@[210.8.40.210])
	by hub.org (8.9.3/8.9.3) with ESMTP id SAA37647
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 24 Feb 2000 18:51:08 -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 042AB75057
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 25 Feb 2000 10:50:30 +1100 (EST)
Message-ID: <38B5C4AA.A84809F2@hotgames.com>
Date: Fri, 25 Feb 2000 10:54:18 +1100
From: Tim Kane <timk@hotgames.com>
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: PSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: arrays of varchar and "
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I don't recall seeing a response to this, so I'm posting it again.
Sorry if you've seen this twice!
(Assuming my original post made it here anyway).

I have.
    create table my_table (
        varchar    stuff[];            # An array of varchar
    };


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?
It seems I am unable to escape it it like \" as I normally would for a '
character.

Instead, the parser seems to chop out a portion of the query string...

Known bug?
Is there a workaround?

Thanks Heaps!!

Tim.