Re: (+) oracle notation

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@nocrew.org>
To: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Thursday, October 19, 2000 12:47 PM
Subject: Re: [GENERAL] (+) oracle notation


> <bmccoy@chapelperilous.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
>