RE: [SQL] OUTER JOINS

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
seemsthat 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
thelist?    >     > 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 -
WayneGretzky