Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90])
	by hub.org (8.9.3/8.9.1) with ESMTP id WAA62392
	for <pgsql-sql@postgreSQL.org>; Mon, 19 Apr 1999 22:14:42 -0400 (EDT)
	(envelope-from michael.j.davis@tvguide.com)
Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by
	corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail
	Service Version 5.5.2448.0)
	id JCBQ5RA0; Mon, 19 Apr 1999 21:14:08 -0500
Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9)
	id <HG14GG6A>; Mon, 19 Apr 1999 21:17:08 -0500
Message-ID: <93C04F1F5173D211A27900105AA8FCFC1453DC@lambic.prevuenet.com>
From: Michael J Davis <michael.j.davis@tvguide.com>
To: "'pgsql-sql@postgreSQL.org'" <pgsql-sql@postgreSQL.org>
Subject: RE:[SQL] OUTER JOINS
Date: Mon, 19 Apr 1999 21:10:39 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2232.9)
Content-Type: text/plain

As far as I have been able to determine, outer joins are not supported in
PostgreSQL.

	-----Original Message-----
	From:	Joe Shevland [SMTP:J_Shevland@TurnAround.com.au]
<mailto:[SMTP:J_Shevland@TurnAround.com.au]> 
	Sent:	Monday, April 19, 1999 12:27 AM
	To:	Dan Janowski
	Cc:	pgsql-sql@postgreSQL.org <mailto:pgsql-sql@postgreSQL.org> 
	Subject:	Re: [SQL] OUTER JOINS

	I didn't see a response for this, so here goes... I believe you can
	implement joins using the followng syntax:

	select t1.value from table_one t1, table_two t2 where t1.key =
t2.key;

	So this would be a straight LEFT join in my understanding. Now, I'm
	venturing beyond my experience with PostgreSQL here, but you may be
able
	to use the associated SQL syntaxes:

	select ... where t1.key *= t2.key
	select ... where t1.key =* t2.key

	etc...

	I hope I'm right here :)

	Regards,
	Joe.

	Dan Janowski wrote:
	> 
	> I've looked through the docs and mail lists but I am coming
	> up short on references for LEFT/RIGHT/FULL OUTER JOIN
	> avalability
	> or functional workarounds. It seems that PostgreSQL does
	> not have it.
	> 
	> Any recommendations on how to aproximate the functionality?
	> 
	> As a curiosity, is there a problem with supporting these
	> OUTER joins or is it merely on the list?
	> 
	> Many thanks,
	> 
	> Dan
	> 
	> --
	> Dan Janowski     danj@3skel.com <mailto:danj@3skel.com>
Triskelion Systems,
	> Inc.     Bronx, NY

	-- 
	---------------------------------------------
	 ,-._|\  | Joe Shevland
	/      \ | Principal Consultant
	\_,--._/ | Turnaround Solutions Pty. Ltd.
	      v  | http://www.TurnAround.com.au
<http://www.TurnAround.com.au> 
	---------------------------------------------
	Skate to where the puck is going and not to
	where it has been - Wayne Gretzky