Allow omitting one or both boundaries in an array slice specifier.
Tom Lane <tgl@sss.pgh.pa.us>
Allow omitting one or both boundaries in an array slice specifier. Omitted boundaries represent the upper or lower limit of the corresponding array subscript. This allows simpler specification of many common use-cases. (Revised version of commit 9246af6799819847faa33baf441251003acbb8fe) YUriy Zhuravlev
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/array.sgml | modified | +27 −0 |
| src/backend/executor/execQual.c | modified | +22 −0 |
| src/backend/nodes/copyfuncs.c | modified | +1 −0 |
| src/backend/nodes/equalfuncs.c | modified | +1 −0 |
| src/backend/nodes/outfuncs.c | modified | +1 −0 |
| src/backend/parser/gram.y | modified | +9 −2 |
| src/backend/parser/parse_node.c | modified | +38 −21 |
| src/backend/parser/parse_target.c | modified | +1 −1 |
| src/backend/utils/adt/arrayfuncs.c | modified | +31 −2 |
| src/backend/utils/adt/ruleutils.c | modified | +2 −0 |
| src/include/nodes/parsenodes.h | modified | +11 −6 |
| src/include/nodes/primnodes.h | modified | +4 −1 |
| src/include/utils/array.h | modified | +2 −0 |
| src/test/regress/expected/arrays.out | modified | +111 −0 |
| src/test/regress/sql/arrays.sql | modified | +41 −0 |