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
Message-ID: <93C04F1F5173D211A27900105AA8FCFC1453DC@lambic.prevuenet.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: michael.j.davis@tvguide.com
Subject: RE:[SQL] OUTER JOINS
In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC1453DC@lambic.prevuenet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox