Re: BUG #7653: Minor problem with join condition

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