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

pgsql: Allow OLD and NEW in multi-row VALUES within rules.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow OLD and NEW in multi-row VALUES within rules.
Date: 2012-08-19 18:12:51
Message-ID: E1T39zX-0006Oa-LN@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Allow OLD and NEW in multi-row VALUES within rules.

Now that we have LATERAL, it's fairly painless to allow this case, which
was left as a TODO in the original multi-row VALUES implementation.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/092d7ded29f36b0539046b23b81b9f0bf2d637f1

Modified Files
--------------
src/backend/optimizer/path/allpaths.c |    4 +-
src/backend/parser/analyze.c          |   46 ++++++++-----------
src/backend/parser/parse_relation.c   |    3 +-
src/backend/utils/adt/ruleutils.c     |   57 ++++++++++++++++++------
src/include/nodes/parsenodes.h        |    2 +-
src/include/parser/parse_relation.h   |    1 +
src/test/regress/expected/rules.out   |   78 +++++++++++++++++++++++++++++++++
src/test/regress/sql/rules.sql        |   20 ++++++++
8 files changed, 164 insertions(+), 47 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2012-08-19 19:25:57
Subject: pgsql: Remove obsolete comment.
Previous:From: Tom LaneDate: 2012-08-18 20:15:08
Subject: pgsql: Make use of LATERAL in information_schema.sequences view.

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