Received: from rmx12.mail.com (rmx12.mail.com [165.251.4.246]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA06898 for ; Sun, 9 Apr 2000 12:46:52 -0400 (EDT) (envelope-from p.lam@altavista.net) From: p.lam@altavista.net Received: from weba6.iname.net (weba6.iname.net [165.251.4.16]) by rmx12.mail.com (8.9.1/8.9.3) with ESMTP id MAA08131 for ; Sun, 9 Apr 2000 12:46:51 -0400 (EDT) Received: (from root@localhost) by weba6.iname.net (8.9.1a/8.9.2.Alpha2) id MAA16792; Sun, 9 Apr 2000 12:46:51 -0400 (EDT) MIME-Version: 1.0 Message-Id: <0004091246518V.24550@weba6.iname.net> Date: Sun, 9 Apr 2000 12:46:51 -0400 (EDT) Content-Type: Text/Plain Content-Transfer-Encoding: 7bit To: pgsql-sql@postgresql.org Subject: JOINs support X-Archive-Number: 200004/86 Trying to execute a very innocent SQL like "Select * FROM A Natural Join B" results in a very horrible : "ERROR: JOIN expressions are not yet implemented" I am running PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 Looking at PostgreSQL's documentation, JOIN indeed is a PostgreSQL keyword. I know I could get around using join(which probably would be better for efficiency) adding something like "WHERE A.attrib=B.attrib", but I would like to know whether JOIN support could be added to PG. Any suggestions?? ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com