Re: LATERAL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: LATERAL
Date
Msg-id 12549.1252367269@sss.pgh.pa.us
Whole thread Raw
In response to Re: LATERAL  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: LATERAL
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Sep 7, 2009 at 3:43 AM, Peter Eisentraut<peter_e@gmx.net> wrote:
>> You could argue that the parser could infer the references and the
>> resultant join ordering restrictions automatically, but perhaps it was
>> deemed that an explicit specification would be less error-prone.

> Well, the irony is that our current code does already infer the
> references - and then disallows them.

Because as often as not, they're mistakes.  Please don't think
you're smarter than the spec here.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: manually setting the command tag (was Re: 8.4: suppress_redundant_updates trigger vs. "Upsert" logic)
Next
From: Robert Haas
Date:
Subject: Re: LATERAL