Horton

Add stratnum GiST support function

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 6db4598fcb82a87a683c4572707e522504830a2b
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2024-01-19T14:42:13Z
Releases: 17.0 
Add stratnum GiST support function

This is support function 12 for the GiST AM and translates
"well-known" RT*StrategyNumber values into whatever strategy number is
used by the opclass (since no particular numbers are actually
required).  We will use this to support temporal PRIMARY
KEY/UNIQUE/FOREIGN KEY/FOR PORTION OF functionality.

This commit adds two implementations, one for internal GiST opclasses
(just an identity function) and another for btree_gist opclasses.  It
updates btree_gist from 1.7 to 1.8, adding the support function for
all its opclasses.

Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Reviewed-by: jian he <jian.universality@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com

Files

PathChange+/−
contrib/btree_gist/btree_gist--1.7--1.8.sql added +87 −0
contrib/btree_gist/btree_gist.c modified +27 −0
contrib/btree_gist/btree_gist.control modified +1 −1
contrib/btree_gist/expected/stratnum.out added +13 −0
contrib/btree_gist/Makefile modified +4 −2
contrib/btree_gist/meson.build modified +2 −0
contrib/btree_gist/sql/stratnum.sql added +3 −0
doc/src/sgml/gist.sgml modified +64 −1
doc/src/sgml/xindex.sgml modified +7 −1
src/backend/access/gist/gistutil.c modified +14 −0
src/backend/access/gist/gistvalidate.c modified +7 −1
src/include/access/gist.h modified +2 −1
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_amproc.dat modified +18 −0
src/include/catalog/pg_proc.dat modified +6 −0
src/test/regress/expected/misc_functions.out modified +13 −0
src/test/regress/sql/misc_functions.sql modified +4 −0

Documentation touched

Discussion