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
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 |