In response to Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> Bill Moran wrote:
>
> > bill=# insert into testarray (a) values (E'{"text \\"for you\\"","moretext"}');
> > INSERT 0 1
> > bill=# select * from testarray;
> > a | id
> > -------------------------------+----
> > {"text \"for you\"",moretext} | 3
>
> Actually this one is good. It gets the backslashes in the output because the "
> need to be escaped there too ('cause it's an array). But if you output a
> single element, they are not there:
Bizarre, but it passes my other tests as well, so I'll have to accept
it as correct ... just seems wrong somehow.
Thanks!
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/