Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes.
pgext.cloud · Source code · Documentation · License text · Control file · PGXN
| Package | pg_device_type |
|---|---|
| Version | 0.0.2 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 4 |
| Latest commit | 2025-03-14 |
| Latest release | 2023-12-13 |
| Catalogue updated | 2026-08-30 |
| tinyint | One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. |
| pg_strverscmp | Natural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order. |
| natord_pg | Natural-order comparison operators and btree operator class for PostgreSQL text values. |
| salesforce_id | Compact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. |
| span | C data type for indexed document text spans, with casts, comparisons, B-tree/hash operator classes, aggregates, and accessors. |
| json_utils | JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. |
| pg_fraction | Adds a fraction data type with arithmetic, comparison, aggregate and B-tree operator-class support. |
| pg_secret | Defines order-revealing encrypted domains, comparison operators, and a B-tree operator class. |