Re: [HACKERS] Re: Table name scope (was Re: [BUGS] Outer joins aren'tworking with views)

[Peter Eisentraut]

Tom Lane writes:

> SELECT * FROM (A NATURAL JOIN B) J            produces ID, CA, CB
>
> SELECT J.* FROM (A NATURAL JOIN B) J          produces ID, CA, CB
>
> SELECT A.* FROM (A NATURAL JOIN B) J          produces ID, CA
>
> SELECT B.* FROM (A NATURAL JOIN B) J          produces ID, CB

ISTM that correlation names aren't allowed after joined tables in the
first place.

         <table reference> ::=
                <table name> [ [ AS ] <correlation name>
                    [ <left paren> <derived column list> <right paren> ] ]
              | <derived table> [ AS ] <correlation name>
                    [ <left paren> <derived column list> <right paren> ]
              | <joined table>

         <joined table> ::=
                <cross join>
              | <qualified join>
              | <left paren> <joined table> <right paren>

-- 
Peter Eisentraut      [EMAIL PROTECTED]       http://yi.org/peter-e/