Postgres Pro
Downloads
Home   >   mailing lists

Re: select result into string's array - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: select result into string's array
Date
Msg-id 20091009074544.GB19581@a-kretschmer.de
Whole thread Raw
In response to select result into string's array  (Alberto Asuero Arroyo <albertoasuero@gmail.com>)
List pgsql-sql
Tree view 
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)

pgsql-sql by date:

Previous
From: Alberto Asuero Arroyo
Date:
Subject: select result into string's array
Next
From: Dmitriy Igrishin
Date:
Subject: Re: select result into string's array