Обсуждение: pgsql: array_offset() and array_offsets()
array_offset() and array_offsets() These functions return the offset position or positions of a value in an array. Author: Pavel Stěhule Reviewed by: Jim Nasby Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/13dbc7a824b3f905904cab51840d37f31a07a9ef Modified Files -------------- doc/src/sgml/array.sgml | 19 ++ doc/src/sgml/func.sgml | 49 +++++ src/backend/utils/adt/array_userfuncs.c | 296 +++++++++++++++++++++++++++++++ src/backend/utils/adt/arrayfuncs.c | 20 ++- src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.h | 6 + src/include/utils/array.h | 6 +- src/pl/plpgsql/src/pl_exec.c | 2 +- src/test/regress/expected/arrays.out | 100 +++++++++++ src/test/regress/sql/arrays.sql | 33 ++++ 10 files changed, 525 insertions(+), 8 deletions(-)