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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, mhipp@mail.pjud.cl, alexaki@ics.forth.gr, wagner@imsd.uni-mainz.de
Subject: Re: outer join in PostgreSql
In-Reply-To: <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