Re: Does the SQL standard actually define LATERAL anywhere?

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> On Sat, 2012-09-01 at 00:29 -0400, Tom Lane wrote:
>> this is a spec-defined syntax so surely the SQL standard ought to tell
>> us what to do. But I'm darned if I see anything in the standard that
>> defines the actual *behavior* of a LATERAL query.

> I have it another read and couldn't find anything either. As written,
> LATERAL is effectively a noise word, AFAICT.

It's not a noise word --- its effects on scope of name visibility are
spelled out clearly enough. What is not clear is what the query
semantics are supposed to be in the presence of references that would
be disallowed in the traditional understanding of a FROM clause.

regards, tom lane