From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
Cc: Alexaki Sofia <alexaki@ics.forth.gr>
Cc: pgsql-sql@postgresql.org, Markus Wagner <wagner@imsd.uni-mainz.de>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: outer join in PostgreSql
Date: Tue, 16 Jan 2001 05:12:29 +0000
Message-ID: <3A63D83D.93FE66A4@alumni.caltech.edu> (raw)
References: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
<012701c07f40$c7c0a6e0$0672148f@cadm.pjud>
Mauricio Hipp Werner wrote:
>
> I need help, which is the symbol used in postgreSql to carry out the outer
> join.
>
> in oracle the is used (+)
> in sybase the is used * and
> in postgreSql?
The PostgreSQL outer join is accomplished using SQL92 syntax. You will
not find real outer joins *except* in the current beta release, and
beware that there may be some tweaks to the grammar to help with
conformance to the standard.
In any case, check the standard or try something like "select * from t1
left outer join t2 on (i)".
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: lockhart@alumni.caltech.edu, mhipp@mail.pjud.cl, alexaki@ics.forth.gr, wagner@imsd.uni-mainz.de, pgsql-interfaces@postgresql.org
Subject: Re: outer join in PostgreSql
In-Reply-To: <3A63D83D.93FE66A4@alumni.caltech.edu>
References: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr> <012701c07f40$c7c0a6e0$0672148f@cadm.pjud> <3A63D83D.93FE66A4@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox