Error in sql sintax

[Abaco informática s.a.]

this sentence is accepted by postgresql sintax analizer but we think that's incorrect:

 

select * from table T where T.field = table.field_1

 

it take the result as an inner join between 'T' and 'table' which not exist ... just exists 'T'.

 

this occurs in linux versions and windows versions.

 

Thanks for your attention.

bye.

Ricardo Solanilla

 

[Stephan Szabo]

On Tue, 9 Nov 2004, [iso-8859-1] Abaco informática s.a. wrote:

> this sentence is accepted by postgresql sintax analizer but we think
> that's incorrect:
>
> select * from table T where T.field = table.field_1
>
> it take the result as an inner join between 'T' and 'table' which not
> exist ... just exists 'T'.

Yes, because PostgreSQL adds defined behavior for such queries beyond that
of the spec for queries which reference tables not mentioned in the from
clause. In recent versions this can be controlled by a runtime parameter
(add_missing_from).

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings