Re: [PATCH] Add sortsupport for range types and btree_gist

Christoph Heiss <christoph.heiss@cybertec.at>

From: Christoph Heiss <christoph.heiss@cybertec.at>
To: Jacob Champion <jchampion@timescale.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Hans-Jürgen Schönig <hs@cybertec.at>, bernd.helmle@cybertec.at
Date: 2022-08-31T19:15:40Z
Lists: pgsql-hackers

Attachments

Hi!

Sorry for the long delay.

This fixes the crashes, now all tests run fine w/ and w/o debug 
configuration. That shouldn't even have slipped through as such.

Notable changes from v1:
- gbt_enum_sortsupport() now passes on fcinfo->flinfo
   enum_cmp_internal() needs a place to cache the typcache entry.
- inet sortsupport now uses network_cmp() directly

Thanks,
Christoph Heiss

Commits

  1. Add support for sorted gist index builds to btree_gist

  2. Add GiST and btree sortsupport routines for range types

  3. Change gist stratnum function to use CompareType

  4. Doc: improve documentation for jsonpath behavior.

  5. Add sortsupport for gist_btree opclasses, for faster index builds.