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