Postgres Pro
Downloads
Home   >   mailing lists

Re: Outer joins and equivalence - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Outer joins and equivalence
Date
Msg-id Pine.LNX.4.64.0805281144200.16756@aragorn.flymine.org
Whole thread Raw
In response to Outer joins and equivalence  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Outer joins and equivalence  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
Tree view 
On Tue, 27 May 2008, Simon Riggs wrote:
> I do recognise that we would *not* be able to deduce this form of SQL
>
> A JOIN B ON (a.id = c.id) LEFT JOIN C ON (b.id = c.id)

Surely that would not be valid SQL?

Matthew

--
Psychotics are consistently inconsistent. The essence of sanity is to
be inconsistently inconsistent.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Outer joins and equivalence
Next
From: Simon Riggs
Date:
Subject: Re: Outer joins and equivalence