Peter Eisentraut <pete...@gmx.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers