Escape double-quotes in text[]?

Поиск
Список
Период
Сортировка
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
rod@iol.ie


В списке pgsql-general по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Planned downtime @ Rackspace - 2014-04-29 2100-2200 UTC
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Escape double-quotes in text[]?