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.