Message-ID: <3A647A62.BB0B0DA@tm.ee>
Date: Tue, 16 Jan 2001 18:44:18 +0200
From: Hannu Krosing <hannu@tm.ee>
MIME-Version: 1.0
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
CC: Thomas Lockhart <lockhart@alumni.caltech.edu>,
	Alexaki Sofia <alexaki@ics.forth.gr>, pgsql-sql@postgresql.org,
	Markus Wagner <wagner@imsd.uni-mainz.de>, pgsql-interfaces@postgresql.org
Subject: Re: outer join in PostgreSql
References: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
	<012701c07f40$c7c0a6e0$0672148f@cadm.pjud>
	<3A63D83D.93FE66A4@alumni.caltech.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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