From: | "Efrain Caro" <betsemes(at)hotmail(dot)com> |
---|---|
To: | "Tomas Berndtsson" <tomas(at)nocrew(dot)org> |
Cc: | "PostgreSQL general mailing list" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: (+) oracle notation |
Date: | 2000-10-19 17:11:15 |
Message-ID: | LAW2-OE69cAgjHXwKHv0000030f@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Example of its use:
select
a.item_number,
b.group_code_description
from
items a,
group_codes b
where
a.group_code = b.group_code (+);
in this example all the records in table "items" appear in the output and
all those records in "group codes" that matches the group_code in items. The
"group_code_description" of all those non-matching records in "group_codes"
table are displayed as NULL.
----- Original Message -----
From: "Tomas Berndtsson" <tomas(at)nocrew(dot)org>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, October 19, 2000 12:47 PM
Subject: Re: [GENERAL] (+) oracle notation
> <bmccoy(at)chapelperilous(dot)net> writes:
>
> > On Thu, 19 Oct 2000, Mathieu Arnold wrote:
> >
> > > I just discovered the (+) oracle join notation, is there something
like
> > > this in postgres ?
> >
> > That's the outer join operator for Oracle, right? I believe that outer
> > joins are coming in 7.2, but I don't know if that means the operator
will
> > be (I don't think it's standard).
>
> What does the operator do? I know what an outer join does, but not
> where that operator comes into the picture.
>
>
> Tomas
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Kreen | 2000-10-19 17:35:54 | Re: MySQL PASSWORD('x') function workalike |
Previous Message | bmccoy | 2000-10-19 17:07:11 | Re: (+) oracle notation |