[GENERAL] SELECT does not find table created by itself

[Andrus]

select * FROM (select 1 as a) t2 
left join t2 t3 ON TRUE

causes error
ERROR:  relation "t2" does not exist

How to fix so that table t2 is created only once ?

Andrus.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general