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.