Sender: danj@3skel.com
Message-ID: <371B2F13.D8B446F6@3skel.com>
Date: Mon, 19 Apr 1999 09:26:43 -0400
From: Dan Janowski <danj@3skel.com>
Organization: Triskelion Systems, Inc.
MIME-Version: 1.0
To: J_Shevland@TurnAround.com.au
CC: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] OUTER JOINS
References: <199904152011.QAA26538@fnur.3skel.com>
	<371ACCB0.6A437C5@TurnAround.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Thanks for giving it a stab. Looking at the available
operators,
there is no =* or *= ops available. Although I am curious
where it
comes from.

Dan


Joe Shevland wrote:
> ... 
> 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
> ...
>
> 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?
> >

--
Dan Janowski     danj@3skel.com       Triskelion Systems,
Inc.     Bronx, NY