Horton

Add bool GiST opclass to btree_gist

Tomas Vondra <tomas.vondra@postgresql.org>

View on postgr.es
Commit: 57e3c5160b24e61758f817feb7aac152cd695c6f
Author: Tomas Vondra <tomas.vondra@postgresql.org>
Date: 2021-11-06T16:00:43Z
Releases: 15.0 
Add bool GiST opclass to btree_gist

Adds bool opclass to btree_gist extension, to allow creating GiST
indexes on bool columns. GiST indexes on a single bool column don't seem
particularly useful, but this allows defining exclusion constraings
involving a bool column, for example.

Author: Emre Hasegeli
Reviewed-by: Andrey Borodin
Discussion: https://postgr.es/m/CAE2gYzyDKJBZngssR84VGZEN=Ux=V9FV23QfPgo+7-yYnKKg4g@mail.gmail.com

Files

PathChange+/−
contrib/btree_gist/btree_bool.c added +169 −0
contrib/btree_gist/btree_gist--1.6--1.7.sql added +62 −0
contrib/btree_gist/btree_gist.control modified +1 −1
contrib/btree_gist/btree_gist.h modified +1 −0
contrib/btree_gist/btree_utils_num.c modified +8 −0
contrib/btree_gist/expected/bool.out added +96 −0
contrib/btree_gist/Makefile modified +3 −2
contrib/btree_gist/sql/bool.sql added +42 −0

Discussion