From: Tim Kane <timk@hotgames.com>
To: PSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: arrays of varchar and "
Date: Fri, 25 Feb 2000 10:54:18 +1100
Message-ID: <38B5C4AA.A84809F2@hotgames.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: timk@hotgames.com
Subject: Re: arrays of varchar and "
In-Reply-To: <38B5C4AA.A84809F2@hotgames.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox