Home > mailing lists

ERROR: OUTER JOIN is not yet supported - Mailing list pgsql-general

From	Jeff Martin
Subject	ERROR: OUTER JOIN is not yet supported
Date	February 2, 2002 16:46:13
Msg-id	NEBBLNMDMLIJEILLDFNBMEAPCFAA.jeff@dgjc.org Whole thread Raw
Responses	Re: ERROR: OUTER JOIN is not yet supported (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Hello...I though PostgreSQL supports OUTER JOIN? Do I need to compile with special options or something?

I am running PostgreSQL 7.0.3 on Linux RedHat 7.1 with Kernel 2.4

psql <<!

job=# select contact, phone from account left outer join phone on account.Id=Phone.AccountId;
ERROR: OUTER JOIN is not yet supported

Thanks for any help,

Jeff

Jeff Martin
704 Torrey Lane, Apartment D
Boalsburg, PA 16827
H814-466-7791
jeff@dgjc.org
www.dgjc.org

From: Tom Lane
Date: 02 February 2002, 16:15:34
Subject: Re: Preformance

From: Tom Lane
Date: 02 February 2002, 16:56:38
Subject: Re: ERROR: OUTER JOIN is not yet supported