[Q] parsing out String array

From: "V S P" <toreason(at)fastmail(dot)fm>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: [Q] parsing out String array
Date: 2009-08-13 03:40:54
Message-ID: 1250134854.31638.1329611489@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2009-08-13 03:45:58 Re: Looping through string constants
Previous Message Alvaro Herrera 2009-08-13 01:15:33 Re: trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport