Magnus Hagander wrote: > > select * FROM (select 1 as a) t2 left join t2 t3 ON TRUE > > causes error > > ERROR: relation "t2" does not exist > Not entirely sure if this is what you're looking for, but I think a > CTE can solve your problem: > WITH t2 AS (SELECT 1 AS a) > SELECT * FROM t2 LEFT JOIN t3 ON TRUE Shouldn't that be: WITH t2 AS (SELECT 1 AS a) SELECT * FROM t2 LEFT JOIN t2 t3 ON TRUE Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
