Joseph S <j...@selectacast.net> writes:
> Supposed I have this table:
> create temp table tempa (ids int[]);
> insert into tempa SELECT ARRAY[1 , 2, 3];
> Now how do I get output from that?
Uh, you didn't actually say what output you're looking for, but
I'm going to guess it's this:
regression=# select unnest(ids) from tempa;
unnest
--------
1
2
3
(3 rows)
Pre-8.4, you need a version of unnest() that's coded in C or SQL;
plpgsql won't do.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
