Horton

Add trim_array() function.

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

View on postgr.es
Commit: 0a687c8f103d217ff1ca8c34a644b380d89bb0ad
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2021-03-03T21:39:57Z
Releases: 14.0 
Add trim_array() function.

This has been in the SQL spec since 2008.  It's a pretty thin
wrapper around the array slice functionality, but the spec
says we should have it, so here it is.

Vik Fearing, reviewed by Dian Fay

Discussion: https://postgr.es/m/fc92ce17-9655-8ff1-c62a-4dc4c8ccd815@postgresfriends.org

Files

PathChange+/−
doc/src/sgml/func.sgml modified +18 −0
src/backend/catalog/sql_features.txt modified +1 −1
src/backend/utils/adt/arrayfuncs.c modified +43 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +3 −0
src/test/regress/expected/arrays.out modified +21 −0
src/test/regress/sql/arrays.sql modified +13 −0

Documentation touched

Discussion