ora_btree_gist

ivorysql : Support for oracle indexing common datatypes in GiST

Overview

ID	Extension	Package	Version	Category	License	Language
9160	ora_btree_gist	ivorysql	`1.0`	SIM	Apache-2.0	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-dt-	No	Yes	No	Yes	no	yes

Relationships
Schemas	`sys`
Requires	ivorysql_ora
Siblings	ivorysql_ora ora_btree_gin pg_get_functiondef plisql gb18030_2022

from contrib/ora_btree_gist/ora_btree_gist.control and package metadata

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`1.0`	18 17 16 15 14	`ivorysql`	`ivorysql_ora`
RPM	PIGSTY	`5.1`	18 17 16 15 14	`ivorysql5`	-
DEB	PIGSTY	`5.1`	18 17 16 15 14	`ivorysql-5`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	MISS	MISS	MISS	MISS	MISS
el8.aarch64	MISS	MISS	MISS	MISS	MISS
el9.x86_64	MISS	MISS	MISS	MISS	MISS
el9.aarch64	MISS	MISS	MISS	MISS	MISS
el10.x86_64	MISS	MISS	MISS	MISS	MISS
el10.aarch64	MISS	MISS	MISS	MISS	MISS
d12.x86_64	MISS	MISS	MISS	MISS	MISS
d12.aarch64	MISS	MISS	MISS	MISS	MISS
d13.x86_64	MISS	MISS	MISS	MISS	MISS
d13.aarch64	MISS	MISS	MISS	MISS	MISS
u22.x86_64	MISS	MISS	MISS	MISS	MISS
u22.aarch64	MISS	MISS	MISS	MISS	MISS
u24.x86_64	MISS	MISS	MISS	MISS	MISS
u24.aarch64	MISS	MISS	MISS	MISS	MISS

Source

Repository

github.com/IvorySQL/IvorySQL/tree/master/contrib/ora_btree_gist

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install ivorysql;		# install via package name, for the active PG version
pig install ora_btree_gist;		# install by extension name, for the current active PG version

pig install ora_btree_gist -v 18;   # install for PG 18

Create this extension with:

CREATE EXTENSION ora_btree_gist CASCADE; -- requires ivorysql_ora

Usage

ora_btree_gist: Support for oracle indexing common datatypes in GiST

The ora_btree_gist extension adds GiST (Generalized Search Tree) operator class support for Oracle-compatible data types provided by IvorySQL.

Enabling

CREATE EXTENSION ora_btree_gist;

Creating GiST Indexes on Oracle Types

This extension allows you to create GiST indexes on Oracle-compatible data types such as NUMBER, VARCHAR2, and Oracle-style DATE, similar to how the standard btree_gist extension works for native PostgreSQL types.

CREATE TABLE t (val NUMBER);
CREATE INDEX t_val_gist_idx ON t USING gist (val);

Use Cases

GiST indexes with Oracle-compatible types enable:

Exclusion constraints using Oracle data types
Nearest-neighbor searches on Oracle-type columns
Range queries with GiST optimizations for Oracle-compatible types

This extension is part of the IvorySQL Oracle compatibility suite and requires ivorysql_ora to be available.

Last updated on 2026-03-12

ora_btree_gin pg_get_functiondef