Horton
Menu

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

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2000-12-19T22:51:35Z
Lists: pgsql-bugs, pgsql-hackers 
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      peter_e@gmx.net       http://yi.org/peter-e/