From: | Michael J Davis <michael(dot)j(dot)davis(at)tvguide(dot)com> |
---|---|
To: | "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | RE: [SQL] OUTER JOINS |
Date: | 1999-04-20 02:34:03 |
Message-ID: | 93C04F1F5173D211A27900105AA8FCFC1453E1@lambic.prevuenet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
As far as I have been able to determine, outer joins are not
supported in PostgreSQL.
-----Original Message-----
From: Joe Shevland [SMTP:J_Shevland(at)TurnAround(dot)com(dot)au]
Sent: Monday, April 19, 1999 12:27 AM
To: Dan Janowski
Cc: pgsql-sql(at)postgreSQL(dot)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(at)3skel(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael J Davis | 1999-04-20 02:34:07 | RE: [SQL] OUTER JOINS |
Previous Message | Anna Langer | 1999-04-20 02:18:11 | Questions about embedded-sql! |