Re: outer join in PostgreSql - Mailing list pgsql-interfaces

From Thomas Lockhart
Subject Re: outer join in PostgreSql
Date
Msg-id 3A63D83D.93FE66A4@alumni.caltech.edu
Whole thread Raw
In response to improve performance  (Alexaki Sofia <alexaki@ics.forth.gr>)
List pgsql-interfaces
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)".


pgsql-interfaces by date:

Previous
From: Michael Fork
Date:
Subject: ODBC and COPY
Next
From: Tom Lane
Date:
Subject: Re: ODBC and COPY