Re: [BUGS] Error in sql sintax

#1

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

Quote:

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

select * from table T where T.field =3D 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Error in sql sintax

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Error in sql sintax - 11-13-2004 , 03:47 PM