| From: | Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add bool GiST opclass to btree_gist |
| Date: | 2021-11-06 16:07:00 |
| Message-ID: | E1mjODc-0000DH-HX@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2021-11-06 16:10:27 | Re: pgsql: Introduce 'bbstreamer' abstraction to modularize pg_basebackup. |
| Previous Message | Tom Lane | 2021-11-06 15:56:50 | pgsql: Second-draft release notes for 14.1. |