From: | Dan Janowski <danj(at)3skel(dot)com> |
---|---|
To: | J_Shevland(at)TurnAround(dot)com(dot)au |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] OUTER JOINS |
Date: | 1999-04-19 13:26:43 |
Message-ID: | 371B2F13.D8B446F6@3skel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)3skel(dot)com Triskelion Systems,
Inc. Bronx, NY
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-04-19 13:38:15 | Re: [SQL] postgres 6.3.2 and regexp |
Previous Message | Guido Piazzi | 1999-04-19 12:54:43 | Re: [SQL] postgres 6.3.2 and regexp |