postgresql

History

Bruce Momjian 29275b1d17 Update copyright for 2024 Reported-by: Michael Paquier Discussion: https://postgr.es/m/ZZKTDPxBBMt3C0J9@paquier.xyz Backpatch-through: 12		2024-01-03 20:49:05 -05:00
..
expected	pg_upgrade: Preserve relfilenodes and tablespace OIDs.	2022-01-17 13:40:27 -05:00
sql	Prevent infinite insertion loops in spgdoinsert().	2021-05-14 15:07:34 -04:00
.gitignore	Fix confusion in SP-GiST between attribute type and leaf storage type.	2021-04-04 14:28:57 -04:00
Makefile	Fix confusion in SP-GiST between attribute type and leaf storage type.	2021-04-04 14:28:57 -04:00
README	Fix confusion in SP-GiST between attribute type and leaf storage type.	2021-04-04 14:28:57 -04:00
meson.build	Update copyright for 2024	2024-01-03 20:49:05 -05:00
spgist_name_ops--1.0.sql	Fix confusion in SP-GiST between attribute type and leaf storage type.	2021-04-04 14:28:57 -04:00
spgist_name_ops.c	Update copyright for 2024	2024-01-03 20:49:05 -05:00
spgist_name_ops.control	Fix confusion in SP-GiST between attribute type and leaf storage type.	2021-04-04 14:28:57 -04:00

README

spgist_name_ops implements an SP-GiST operator class that indexes
columns of type "name", but with storage identical to that used
by SP-GiST text_ops.

This is not terribly useful in itself, perhaps, but it allows
testing cases where the indexed data type is different from the leaf
data type and yet we can reconstruct the original indexed value.
That situation is not tested by any built-in SP-GiST opclass.