From: | Tim Kane <timk(at)hotgames(dot)com> |
---|---|
To: | PSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | arrays of varchar and " |
Date: | 2000-02-24 23:54:18 |
Message-ID: | 38B5C4AA.A84809F2@hotgames.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-02-25 01:03:37 | Re: [INTERFACES] arrays of varchar and " |
Previous Message | Ed Loehr | 2000-02-24 23:50:21 | Re: [INTERFACES] selectecting not null varchars. |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-02-24 23:57:50 | Re: [SQL] how to create index on timestamp field in pre v7 database |
Previous Message | M.Mazurek | 2000-02-24 22:38:48 | date_part, too many results? |