Re: [SQL] SELECT FROM SELECT

[Tom Lane]

"Aleksey V. Kurinov" <[EMAIL PROTECTED]> 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