pg_lion_citext
pg_lion : Case-insensitive citext operator class for lion indexes
Overview
| ID | Extension | Package | Version | Category | License | Language |
|---|---|---|---|---|---|---|
| 2716 | pg_lion_citext | pg_lion | 0.3.0 |
FEAT | PostgreSQL | SQL |
| Attribute | Has Binary | Has Library | Need Load | Has DDL | Relocatable | Trusted |
|---|---|---|---|---|---|---|
| ----d-r | No | No | No | Yes | yes | no |
| Relationships | |
|---|---|
| Requires | pg_lion citext |
| Siblings | pg_lion pg_lion_vector |
Packages
| Linux / PG | PG19 | PG18 | PG17 | PG16 | PG15 |
|---|---|---|---|---|---|
| el8.x86_64 | N/A | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| el8.aarch64 | N/A | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| el9.x86_64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| el9.aarch64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| el10.x86_64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| el10.aarch64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| d12.x86_64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| d12.aarch64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| d13.x86_64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| d13.aarch64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| u22.x86_64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| u22.aarch64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| u24.x86_64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| u24.aarch64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| u26.x86_64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
| u26.aarch64 | MISS | PIGSTY 0.3.0 | PIGSTY 0.3.0 | PIGSTY 0.3.0 | N/A |
Source
github.com/cgkanchi/pg_lion
pg_lion-0.3.0.tar.gz
Install
Make sure PGDG and PIGSTY repo available:
Install this extension with pig:
Create this extension with:
Usage
Sources:
pg_lion_citext 0.3.0 registers the citext_ops operator class for case-insensitive text keys in lion indexes. It is a SQL companion shipped with pg_lion, with no separate shared library.
Core Workflow
Create citext and pg_lion first, then enable the companion. Its default operator class uses citext hashing and comparison functions for equality, inequality and ranges (=, <>, <, <=, >=, >).
The example returns two rows in the count because both spellings compare equal. Applications keep using ordinary citext predicates.
Operational Boundaries
Requires PostgreSQL 16 or later and superuser installation. Case folding and ordering follow citext semantics. Use matching files from the parent distribution. The parent indexes retain their visibility, VACUUM, and optional custom-WAL preload requirements. This companion does not enable preloading or change existing indexes by itself.