In response to Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> Hello
>
> try
> postgres=# SELECT ARRAY['text "for you" some'];
> array
> ---------------------------
> {"text \"for you\" some"}
> (1 row)
Thanks, and I'm aware of that, but it doesn't answer the original
question. The code I'm writing is back-end code that other developers
will use to submit queries.
I don't have the luxury of changing their queries from {} syntax to
[] syntax at runtime. However, if this is something that can't be
done with {}, I can catch it during data validation and throw a useful
error.
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/