Re: select result into string's array

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
------foobarbatz
(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)