ora_btree_gist

Overview

from contrib/ora_btree_gist/ora_btree_gist.control and package metadata

Version

Install

You can install ivorysql directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

• Install
• pig
• dnf
• apt

pig install ivorysql;          # Install for current active PG version

pig ext install -y ivorysql -v 18  # PG 18

dnf install -y ivorysql5       # PG 18

apt install -y ivorysql-5   # PG 18

Create Extension:

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.