[Q] parsing out String array

Поиск
Список
Период
Сортировка
От V S P
Тема [Q] parsing out String array
Дата
Msg-id 1250134854.31638.1329611489@webmail.messagingengine.com
обсуждение исходный текст
Ответы Re: [Q] parsing out String array
Список pgsql-general
if I have field declared
myvalue text[][]

insert into vladik (myval)
values
(
'{{"\",A", "\"B"}, {"Y", "Q"}}'
)


What do you guys use in your treasurechest of 'addons'
to successfully parse out the above trickery
and get

and get the 4 strings
",A
"B
Y
Q

from within Postgres stored procedure as well as C++ or other client
code.


It seems to me that it is not possible with any built-in command
available
to easily extract the strings out to a multidimensional array


thank you
--
Vlad P
author of C++  ORM  http://github.com/vladp/CppOrm/tree/master


--
http://www.fastmail.fm - One of many happy users:
  http://www.fastmail.fm/docs/quotes.html


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport
Следующее
От: Scott Bailey
Дата:
Сообщение: Re: Looping through string constants