Re: Outer joins and equivalence

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Outer joins and equivalence
Date: 2008-05-28 10:45:14
Message-ID: Pine.LNX.4.64.0805281144200.16756@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavan Deolasee 2008-05-28 11:26:50 Avoiding second heap scan in VACUUM
Previous Message Gregory Stark 2008-05-28 10:08:12 Re: Hint Bits and Write I/O

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2008-05-28 13:39:10 Re: Outer joins and equivalence
Previous Message Tom Lane 2008-05-27 21:43:12 Re: Outer joins and equivalence