Add SQL function array_reverse()
authorMichael Paquier <michael@paquier.xyz>
Fri, 1 Nov 2024 01:32:19 +0000 (10:32 +0900)
committerMichael Paquier <michael@paquier.xyz>
Fri, 1 Nov 2024 01:32:19 +0000 (10:32 +0900)
commit49d6c7d8dabad8c59ba21afe72ff32e79f822291
tree9e73aceb9839531075f21edf08802ace845416e3
parent2d8bff603c9ee7b284b85016fd1a8849ee36368d
Add SQL function array_reverse()

This function takes in input an array, and reverses the position of all
its elements.  This operation only affects the first dimension of the
array, like array_shuffle().

The implementation structure is inspired by array_shuffle(), with a
subroutine called array_reverse_n() that may come in handy in the
future, should more functions able to reverse portions of arrays be
introduced.

Bump catalog version.

Author: Aleksander Alekseev
Reviewed-by: Ashutosh Bapat, Tom Lane, Vladlen Popolitov
Discussion: https://postgr.es/m/CAJ7c6TMpeO_ke+QGOaAx9xdJuxa7r=49-anMh3G5476e3CX1CA@mail.gmail.com
doc/src/sgml/func.sgml
src/backend/utils/adt/array_userfuncs.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/arrays.out
src/test/regress/sql/arrays.sql