Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-performance by date

Next:From: Simon RiggsDate: 2008-05-28 13:39:10
Subject: Re: Outer joins and equivalence
Previous:From: Tom LaneDate: 2008-05-27 21:43:12
Subject: Re: Outer joins and equivalence

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group