Re: [INTERFACES] outer join in PostgreSql - Mailing list pgsql-sql

From Hannu Krosing
Subject Re: [INTERFACES] outer join in PostgreSql
Date
Msg-id 3A647A62.BB0B0DA@tm.ee
Whole thread Raw
In response to improve performance  (Alexaki Sofia <alexaki@ics.forth.gr>)
Responses Re: [INTERFACES] outer join in PostgreSql
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: sort order with < & > in varchar fields
Next
From: Josh Berkus
Date:
Subject: Re: Re: Boolean and Bit