pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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:34:03 -0500
Message-ID: <93C04F1F5173D211A27900105AA8FCFC1453E1@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]
		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



view thread (38+ messages)  latest in thread

Message-ID: <93C04F1F5173D211A27900105AA8FCFC1453E1@lambic.prevuenet.com>
Permalink:  ../93C04F1F5173D211A27900105AA8FCFC1453E1@lambic.prevuenet.com/
Also on:    postgresql.org/message-id/93C04F1F5173D211A27900105AA8FCFC1453E1@lambic.prevuenet.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: michael.j.davis@tvguide.com
  Subject: Re: [SQL] OUTER JOINS
  In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC1453E1@lambic.prevuenet.com>
  References: <93C04F1F5173D211A27900105AA8FCFC1453E1@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