Re: outer join in PostgreSql

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Mauricio Hipp Werner <mhipp(at)mail(dot)pjud(dot)cl>
Cc: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>, pgsql-sql(at)postgresql(dot)org, Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: outer join in PostgreSql
Date: 2001-01-16 05:12:29
Message-ID: 3A63D83D.93FE66A4@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Fork 2001-01-16 05:36:59 ODBC and COPY FROM
Previous Message xriley 2001-01-16 02:51:16 Deleting a list of external xinv/xinx files using JDBC

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-01-16 05:12:53 Yet one more question
Previous Message Josh Berkus 2001-01-16 05:10:51 Re: Question #4 about PL/PGSQL