Re: (+) oracle notation

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
>

In response to

Browse pgsql-general by date

  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