Received: from myst.fourpalms.org ([128.171.71.193])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0G6Bj043449;
	Tue, 16 Jan 2001 01:11:45 -0500 (EST)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1])
	by myst.fourpalms.org (Postfix) with ESMTP
	id 8A89BC548; Tue, 16 Jan 2001 05:12:29 +0000 (UTC)
Message-ID: <3A63D83D.93FE66A4@alumni.caltech.edu>
Date: Tue, 16 Jan 2001 05:12:29 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
Organization: Yes
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
Cc: 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>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200101/151
X-Sequence-Number: 765

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)".