| 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: | Whole Thread | Raw Message | 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 |