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