Horton

Support assignment to subfields of composite columns in UPDATE and INSERT.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 7e64dbc6b5e516a2510ae41c8c7999d1d8d25872
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2004-06-09T19:08:20Z
Releases: 8.0.0 
Support assignment to subfields of composite columns in UPDATE and INSERT.
As a side effect, cause subscripts in INSERT targetlists to do something
more or less sensible; previously we evaluated such subscripts and then
effectively ignored them.  Another side effect is that UPDATE-ing an
element or slice of an array value that is NULL now produces a non-null
result, namely an array containing just the assigned-to positions.

Files

PathChange+/−
doc/src/sgml/ref/insert.sgml modified +7 −6
doc/src/sgml/ref/update.sgml modified +5 −2
doc/src/sgml/rowtypes.sgml modified +65 −1
src/backend/executor/execQual.c modified +190 −48
src/backend/nodes/copyfuncs.c modified +25 −10
src/backend/nodes/equalfuncs.c modified +18 −8
src/backend/nodes/outfuncs.c modified +74 −11
src/backend/nodes/readfuncs.c modified +19 −28
src/backend/optimizer/util/clauses.c modified +32 −1
src/backend/parser/analyze.c modified +2 −1
src/backend/parser/gram.y modified +169 −106
src/backend/parser/parse_clause.c modified +2 −3
src/backend/parser/parse_expr.c modified +62 −43
src/backend/parser/parse_node.c modified +68 −57
src/backend/parser/parse_target.c modified +323 −77
src/backend/rewrite/rewriteHandler.c modified +109 −21
src/backend/utils/adt/ruleutils.c modified +157 −79
src/include/nodes/execnodes.h modified +13 −1
src/include/nodes/nodes.h modified +4 −2
src/include/nodes/parsenodes.h modified +36 −26
src/include/nodes/primnodes.h modified +32 −3
src/include/parser/parse_node.h modified +4 −3
src/pl/plpgsql/src/pl_exec.c modified +13 −1
src/test/regress/expected/arrays.out modified +15 −16
src/test/regress/expected/rowtypes.out modified +13 −9
src/test/regress/sql/arrays.sql modified +4 −5
src/test/regress/sql/rowtypes.sql modified +5 −4