JOINs support - Mailing list pgsql-sql

From p.lam@altavista.net
Subject JOINs support
Date
Msg-id 0004091246518V.24550@weba6.iname.net
Whole thread Raw
Responses Re: JOINs support  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
List pgsql-sql
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
probablywould be better for efficiency) adding something like "WHERE A.attrib=B.attrib", but I would like to know
whetherJOIN support could be added to PG.
 

Any suggestions??

----------------------------------------------------------------
Get your free email from AltaVista at http://altavista.iname.com


pgsql-sql by date:

Previous
From: jmac@nemesis.com.au ("Jay")
Date:
Subject: pgsql-sql
Next
From: sam_ma@hksmartone.com
Date:
Subject: Question on the datatype binary