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

pgsql: Make LATERAL implicit for functions in FROM.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make LATERAL implicit for functions in FROM.
Date: 2013-01-26 21:19:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Make LATERAL implicit for functions in FROM.

The SQL standard does not have general functions-in-FROM, but it does
allow UNNEST() there (see the <collection derived table> production),
and the semantics of that are defined to include lateral references.
So spec compliance requires allowing lateral references within UNNEST()
even without an explicit LATERAL keyword.  Rather than making UNNEST()
a special case, it seems best to extend this flexibility to any
function-in-FROM.  We'll still allow LATERAL to be written explicitly
for clarity's sake, but it's now a noise word in this context.

In theory this change could result in a change in behavior of existing
queries, by allowing what had been an outer reference in a function-in-FROM
to be captured by an earlier FROM-item at the same level.  However, all
pre-9.3 PG releases have a bug that causes them to match variable
references to earlier FROM-items in preference to outer references (and
then throw an error).  So no previously-working query could contain the
type of ambiguity that would risk a change of behavior.

Per a suggestion from Andrew Gierth, though I didn't use his patch.



Modified Files
doc/src/sgml/queries.sgml                |   20 +++++++++++---
doc/src/sgml/ref/select.sgml             |   41 ++++++++++++++++++++---------
src/backend/parser/parse_clause.c        |   21 +++++++++++---
src/test/regress/expected/join.out       |   37 +++++++++++++++++---------
src/test/regress/expected/rangefuncs.out |   13 ++++++---
src/test/regress/sql/join.sql            |   13 ++++++---
src/test/regress/sql/rangefuncs.sql      |    2 +-
7 files changed, 101 insertions(+), 46 deletions(-)

pgsql-committers by date

Next:From: Michael MeskesDate: 2013-01-27 12:51:33
Subject: pgsql: Made ecpglib use translated messages.
Previous:From: Bruce MomjianDate: 2013-01-26 19:52:04
Subject: pgsql: Update comments in new DROP IF EXISTS code;commit message updat

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