Обсуждение: JOINs support

Поиск
Список
Период
Сортировка

JOINs support

От
p.lam@altavista.net
Дата:
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


Re: JOINs support

От
Peter Eisentraut
Дата:
On Sun, 9 Apr 2000 p.lam@altavista.net wrote:

> I would like to know whether JOIN support could be added to PG.

It's planned for 7.1.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden