Message-ID: <93C04F1F5173D211A27900105AA8FCFC1453D7@lambic.prevuenet.com>
From: Michael J Davis <michael.j.davis@tvguide.com>
To: pgsql-sql@postgreSQL.org
Subject: RE: [SQL] OUTER JOINS
Date: Mon, 19 Apr 1999 10:16:42 -0500
MIME-Version: 1.0
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]
> Sent:	Monday, April 19, 1999 12:27 AM
> To:	Dan Janowski
> Cc:	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       Triskelion Systems,
> > Inc.     Bronx, NY
> 
> -- 
> ---------------------------------------------
>  ,-._|\  | Joe Shevland
> /      \ | Principal Consultant
> \_,--._/ | Turnaround Solutions Pty. Ltd.
>       v  | http://www.TurnAround.com.au
> ---------------------------------------------
> Skate to where the puck is going and not to
> where it has been - Wayne Gretzky