Re: SELECT FROM SELECT - Mailing list pgsql-sql

"Aleksey V. Kurinov" <leks@datanaut.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