From: Hannu Krosing <hannu@tm.ee>
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>
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 18:44:18 +0200
Message-ID: <3A647A62.BB0B0DA@tm.ee> (raw)
References: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
<012701c07f40$c7c0a6e0$0672148f@cadm.pjud>
<3A63D83D.93FE66A4@alumni.caltech.edu>
Thomas Lockhart wrote:
>
> 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)".
To get a feel you could use MS Access visual query builder and then view
the source.
I have not checked it lately, but it very likely produces SQL92
compliant outer joins.
-----------
Hannu
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: hannu@tm.ee, mhipp@mail.pjud.cl, lockhart@alumni.caltech.edu, alexaki@ics.forth.gr, wagner@imsd.uni-mainz.de
Subject: Re: outer join in PostgreSql
In-Reply-To: <3A647A62.BB0B0DA@tm.ee>
* 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