pgsql: Add array_remove() and array_replace() functions.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add array_remove() and array_replace() functions.
Date: 2012-07-11 17:59:50
Message-ID: E1Sp1CY-00054e-Vl@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add array_remove() and array_replace() functions.

These functions support removing or replacing array element value(s)
matching a given search value. Although intended mainly to support a
future array-foreign-key feature, they seem useful in their own right.

Marco Nenciarini and Gabriele Bartolini, reviewed by Alex Hunsaker

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/84a42560c82aeb9f3690d93a0d03cf544f53b89b

Modified Files
--------------
doc/src/sgml/func.sgml | 29 ++++
src/backend/utils/adt/arrayfuncs.c | 306 ++++++++++++++++++++++++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 4 +
src/include/utils/array.h | 2 +
src/test/regress/expected/arrays.out | 62 +++++++
src/test/regress/sql/arrays.sql | 11 ++
7 files changed, 415 insertions(+), 1 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message User Hinoue 2012-07-11 21:30:08 psqlodbc - psqlodbc: Fix the bug which causes a segfault in
Previous Message Bruce Momjian 2012-07-11 03:08:32 pgsql: Document that Log-Shipping Standby Servers cannot be upgraded by