Extensions / Functions and aggregates
Natural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order.
pgext.cloud · Source code · Documentation · Control file
| Package | pg_strverscmp |
|---|---|
| Version | 1.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 2 |
| Latest commit | 2017-04-19 |
| Catalogue updated | 2026-08-30 |
| natord_pg | Natural-order comparison operators and btree operator class for PostgreSQL text values. |
| parray_gin | GIN index operator class and partial-match operators for text arrays |
| pg_secret | Defines order-revealing encrypted domains, comparison operators, and a B-tree operator class. |
| device_type | Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes. |
| json_utils | JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. |
| rum | RUM index access method |
| pg_fraction | Adds a fraction data type with arithmetic, comparison, aggregate and B-tree operator-class support. |
| wildspeed | GIN operator class for fast wildcard LIKE searches using permuterm indexing |