| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Mauricio Hipp Werner <mhipp(at)mail(dot)pjud(dot)cl> |
| Cc: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, 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 16:44:18 |
| Message-ID: | 3A647A62.BB0B0DA@tm.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2001-01-16 19:33:03 | Re: Re: [SQL] improve performance |
| Previous Message | Tom Lane | 2001-01-16 16:21:38 | Re: 7.1 Beta3 bug when using ODBC |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-01-16 16:52:18 | Re: deferred constraints failing on commit |
| Previous Message | Borek Lupoměský | 2001-01-16 15:17:35 | Re: outer join in PostgreSql |