Received: from lscorp.com (poohbah.lscorp.com [207.152.64.2]) by hub.org (8.8.8/8.7.5) with ESMTP id VAA00973 for ; Thu, 25 Jun 1998 21:56:25 -0400 (EDT) Received: from [207.152.64.133] by lscorp.com with SMTP (Eudora Internet Mail Server 1.2); Thu, 25 Jun 1998 20:54:31 -0500 X-Sender: lynch@poohbah.lscorp.com Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: pgsql-sql@postgresql.org From: lynch@lscorp.com (Richard Lynch) Subject: SQL Bug? Date: Thu, 25 Jun 1998 20:54:31 -0500 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