C data type for indexed document text spans, with casts, comparisons, B-tree/hash operator classes, aggregates, and accessors.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_span |
|---|---|
| Version | 0.1.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 1 |
| Latest commit | 2017-05-06 |
| Latest release | 2017-05-05 |
| Catalogue updated | 2026-08-30 |
| tinyint | One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. |
| 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 |
| salesforce_id | Compact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. |
| hyperspace | Four-dimensional point, box, and circle types with B-tree and SP-GiST/KD-tree operator classes. |
| pg_fraction | Adds a fraction data type with arithmetic, comparison, aggregate and B-tree operator-class support. |
| pg_s2 | Adds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class. |
| pg_siren | Validated French SIREN and SIRET identifier types with B-tree and hash index support. |