[Q] parsing out String array - Mailing list pgsql-general

From V S P
Subject [Q] parsing out String array
Date
Msg-id 1250134854.31638.1329611489@webmail.messagingengine.com
Whole thread Raw
Responses Re: [Q] parsing out String array  (Scott Bailey <artacus@comcast.net>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport
Next
From: Scott Bailey
Date:
Subject: Re: Looping through string constants