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