Re: [INTERFACES] arrays of varchar and " - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] arrays of varchar and "
Date
Msg-id 23718.951440617@sss.pgh.pa.us
Whole thread Raw
In response to arrays of varchar and "  (Tim Kane <timk@hotgames.com>)
Responses Re: [INTERFACES] arrays of varchar and "  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Tim Kane
Date:
Subject: arrays of varchar and "
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] arrays of varchar and "