diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2024-09-17 10:19:26 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2024-09-17 11:29:29 +0200 |
| commit | 7406ab623fee1addcb21c881afecbe638a0d56e9 (patch) | |
| tree | 6c75a0f795ecec184e0cb9dcd05ed74bd324a6c6 /contrib/btree_gist/expected | |
| parent | 95d6e9af07d2e5af2fdd272e72b5b552bad3ea0a (diff) | |
| download | postgresql-7406ab623fee1addcb21c881afecbe638a0d56e9.tar.gz postgresql-7406ab623fee1addcb21c881afecbe638a0d56e9.zip | |
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.
(previously committed as 6db4598fcb8, reverted by 8aee330af55; this is
essentially unchanged from those)
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
Diffstat (limited to 'contrib/btree_gist/expected')
| -rw-r--r-- | contrib/btree_gist/expected/stratnum.out | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/contrib/btree_gist/expected/stratnum.out b/contrib/btree_gist/expected/stratnum.out new file mode 100644 index 00000000000..9d80c6590d9 --- /dev/null +++ b/contrib/btree_gist/expected/stratnum.out @@ -0,0 +1,13 @@ +-- test stratnum support func +SELECT gist_stratnum_btree(3::smallint); + gist_stratnum_btree +--------------------- + 0 +(1 row) + +SELECT gist_stratnum_btree(18::smallint); + gist_stratnum_btree +--------------------- + 3 +(1 row) + |