SQL Bug?
Richard Lynch <lynch@lscorp.com>
From: lynch@lscorp.com (Richard Lynch)
To: pgsql-sql@postgresql.org
Date: 1998-06-26T01:54:31Z
Lists: pgsql-sql
I'm far from an SQL expert, but... select field1 from table1 where table2.field2 = table1.field3; This query, which uses tables in the where clause that aren't in the list of tables, actually does what one would sorta expect in PostgreSQL, but isn't it a bug for it to do that?... Not that I mind, since it's what I accidentally coded anyways. -- -- -- "TANSTAAFL" Rich lynch@lscorp.com