I've seen this asked in the archives, but there was never any answer.
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? None of these work: (xunnest is my
version of unnest since I'm using 8.2.x)
select * FROM xunnest(tempa.ids);
SELECT * FROM (select * FROM xunnest(tempa.ids) AS aa) AS ab, tempa;
SELECT * FROM ( select * FROM xunnest(ta.ids) AS aa) AS ab, tempa ta;
SELECT * FROM tempa ta, ( select * FROM xunnest(ta.ids) AS aa) AS ab;
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql