"Aleksey V. Kurinov" <leks(at)datanaut(dot)com> writes:
> Does Postrges provide "Select * from Select * from t1" construction ?
In 7.1.
But you have to spell it per the SQL spec:
select * from (select * from t1) as foo;
The parentheses and alias name are not optional.
regards, tom lane