Re: BUG #7653: Minor problem with join condition - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7653: Minor problem with join condition
Date
Msg-id 13179.1352730603@sss.pgh.pa.us
Whole thread Raw
In response to BUG #7653: Minor problem with join condition  (stefano@sportilia.com)
List pgsql-bugs
stefano@sportilia.com writes:
> Don't know if this is a bug or a correct behaviour, but in a query like
> this:

> SELECT t1.* FROM
> table1 t1 JOIN
> table2 t2 ON t1.id = t2.t1id JOIN
> table3 t3 ON t1.id = t2.t1id

> The parser should return an error because we are joining a table without
> using any of its column.

There is no such restriction in the SQL standard.

            regards, tom lane

pgsql-bugs by date:

Previous
From: stefano@sportilia.com
Date:
Subject: BUG #7653: Minor problem with join condition
Next
From: Niels Kristian Schjødt
Date:
Subject: Bug in postgres 9.2 installation: pg_archivecleanup: command not found