In response to Alberto Asuero Arroyo :
> Hi,
>
> I need to store the result of select into an array of string:
test=*# select * from foo;
t
------
foo
bar
batz
(3 rows)
test=*# select array_agg(t) from foo;
array_agg
----------------
{foo,bar,batz}
(1 row)
Helps that?
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
