Re: Badly planned queries with JOIN syntax - Mailing list pgsql-general

From Greg Stark
Subject Re: Badly planned queries with JOIN syntax
Date
Msg-id 87d6jzy3r5.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Badly planned queries with JOIN syntax  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:

> On Fri, 4 Apr 2003, Phil Mayers wrote:
>
> > ANSI SQL92 had a "table.column *= otable.ocolumn" which equates to "table LEFT
> > OUTER JOIN otable on column=ocolumn").
>
> AFAICT SQL92 has no such syntax. It's hard to do without alot of
> limitations (because join order can be important to the results of the
> query with outer joins).

Fwiw, this is MSSQL's (and presumably Sybase's?) non-standard outer join syntax.

--
greg

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: Factoring where clauses through unions
Next
From: Ian Barwick
Date:
Subject: Re: PHP as PL