Hi all,

Probably a silly question, but I'm having trouble figuring out the
answer... if I'm constructing an string representation of a value to go
into a text[] column, and one of the text literals includes
double-quotes, do I need to escape the literal?

For example, can I insert something like this into a text[] column
directly? -

  '{"abc", "de"f"}'

Or would I need to do this? -

  E'{"abc", "de"f"}'

....or something different again? I'm doing this from PHP via the Zend
framework (v.1) if it makes any difference.

Thanks,

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to