Adds a compact S-expression type with parsing, list operations, matching, containment, and hash/GIN indexing.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_sexp |
|---|---|
| Version | 0.1.0 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 2 |
| Latest commit | 2025-12-07 |
| Catalogue updated | 2026-08-30 |
| postcode | Store UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing |
| hstore_ops | Alternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries. |
| tinyint | One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. |
| wildspeed | GIN operator class for fast wildcard LIKE searches using permuterm indexing |
| parray_gin | GIN index operator class and partial-match operators for text arrays |
| device_type | Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes. |
| ksj | Japanese kanji-numeral integer type with arithmetic, aggregates, casts, comparison, and B-tree indexing |
| span | C data type for indexed document text spans, with casts, comparisons, B-tree/hash operator classes, aggregates, and accessors. |