pgsql: Add bool GiST opclass to btree_gist - Mailing list pgsql-committers

From Tomas Vondra
Subject pgsql: Add bool GiST opclass to btree_gist
Date
Msg-id E1mjODc-0000DH-HX@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/57e3c5160b24e61758f817feb7aac152cd695c6f

Modified Files
--------------
contrib/btree_gist/Makefile                 |   5 +-
contrib/btree_gist/btree_bool.c             | 169 ++++++++++++++++++++++++++++
contrib/btree_gist/btree_gist--1.6--1.7.sql |  62 ++++++++++
contrib/btree_gist/btree_gist.control       |   2 +-
contrib/btree_gist/btree_gist.h             |   1 +
contrib/btree_gist/btree_utils_num.c        |   8 ++
contrib/btree_gist/expected/bool.out        |  96 ++++++++++++++++
contrib/btree_gist/sql/bool.sql             |  42 +++++++
8 files changed, 382 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Second-draft release notes for 14.1.
Next
From: Tomas Vondra
Date:
Subject: Re: pgsql: Introduce 'bbstreamer' abstraction to modularize pg_basebackup.