Re: GiST operator class for bool

x4mmm@yandex-team.ru

From: Andrey Borodin <x4mmm@yandex-team.ru>
To: emre@hasegeli.com
Cc: pgsql-hackers@postgresql.org
Date: 2021-06-08T11:07:32Z
Lists: pgsql-hackers
Hi!

> 8 июня 2021 г., в 13:48, Emre Hasegeli <emre@hasegeli.com> написал(а):
> 
> It could be useful to use bool in exclusion constraints, but it's
> currently not nicely supported.  The attached patch adds support for
> bool to the btree_gist extension, so we can do this.
> 
> I am adding this to the commitfest 2021-07.
> <0001-btree_gist-Support-bool.patch>

It definitely makes sense to include bool into list of supported types.
But patch that you propose does not support sorting build added in PG14.
Or we can add this functionality later in https://commitfest.postgresql.org/31/2824/ ...

Thanks!

Best regards, Andrey Borodin.


Commits

  1. Add bool to btree_gist documentation

  2. Fix gist_bool_ops to use gbtreekey2

  3. Add bool GiST opclass to btree_gist