Re: [SQL] ERROR: function expression in FROM may not refer to other relations of same query level

2009-07-08 Thread Tom Lane
Joseph S 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) f

[SQL] ERROR: function expression in FROM may not refer to other relations of same query level

2009-07-08 Thread Joseph S
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) se