Add cross-type comparisons to contrib/btree_gin.
Tom Lane <tgl@sss.pgh.pa.us>
Add cross-type comparisons to contrib/btree_gin. Extend the infrastructure in btree_gin.c to permit cross-type operators, and add the code to support them for the int2, int4, and int8 opclasses. (To keep this patch digestible, I left the other datatypes for a separate patch.) This improves the usability of btree_gin indexes by allowing them to support the same set of queries that a regular btree index does. Author: Tom Lane <tgl@sss.pgh.pa.us> Reviewed-by: Arseniy Mukhin <arseniy.mukhin.dev@gmail.com> Discussion: https://postgr.es/m/262624.1738460652@sss.pgh.pa.us
Files
| Path | Change | +/− |
|---|---|---|
| contrib/btree_gin/btree_gin--1.3--1.4.sql | added | +63 −0 |
| contrib/btree_gin/btree_gin.c | modified | +397 −82 |
| contrib/btree_gin/btree_gin.control | modified | +1 −1 |
| contrib/btree_gin/expected/int2.out | modified | +190 −0 |
| contrib/btree_gin/expected/int4.out | modified | +100 −0 |
| contrib/btree_gin/expected/int8.out | modified | +100 −0 |
| contrib/btree_gin/Makefile | modified | +1 −1 |
| contrib/btree_gin/meson.build | modified | +1 −0 |
| contrib/btree_gin/sql/int2.sql | modified | +35 −0 |
| contrib/btree_gin/sql/int4.sql | modified | +18 −0 |
| contrib/btree_gin/sql/int8.sql | modified | +18 −0 |
| doc/src/sgml/gin.sgml | modified | +5 −1 |
| src/tools/pgindent/typedefs.list | modified | +2 −0 |
Discussion
- Cross-type index comparison support in contrib/btree_gin 12 messages · 2025-02-02 → 2025-07-03