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
