uint
unsigned integer types
pguint : unsigned integer types
Overview
| ID | Extension | Package | Version | Category | License | Language |
|---|---|---|---|---|---|---|
| 3730 | uint | pguint | 1.20250815 |
TYPE | PostgreSQL | C |
| Attribute | Has Binary | Has Library | Need Load | Has DDL | Relocatable | Trusted |
|---|---|---|---|---|---|---|
| --s-d-r | No | Yes | No | Yes | yes | no |
no pg14 for el8/el9 pgdg repo
Packages
| Type | Repo | Version | PG Major Compatibility | Package Pattern | Dependencies |
|---|---|---|---|---|---|
| EXT | MIXED | 1.20250815 |
18 17 16 15 14 | pguint |
- |
| RPM | PIGSTY | 1.20250815 |
18 17 16 15 14 | pguint_$v |
- |
| DEB | PIGSTY | 1.20250815 |
18 17 16 15 14 | postgresql-$v-pguint |
- |
| Linux / PG | PG18 | PG17 | PG16 | PG15 | PG14 |
|---|---|---|---|---|---|
| el8.x86_64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| el8.aarch64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| el9.x86_64 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PIGSTY 1.20250815 |
| el9.aarch64 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PIGSTY 1.20250815 |
| el10.x86_64 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PIGSTY 1.20250815 |
| el10.aarch64 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PGDG 1.20250815 | PIGSTY 1.20250815 |
| d12.x86_64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| d12.aarch64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| d13.x86_64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| d13.aarch64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| u22.x86_64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| u22.aarch64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| u24.x86_64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| u24.aarch64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| u26.x86_64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
| u26.aarch64 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 | PIGSTY 1.20250815 |
Source
github.com/petere/pguint
pguint-1.20250815.tar.gz
Install
Make sure PGDG and PIGSTY repo available:
Install this extension with pig:
Create this extension with:
Usage
The uint extension adds unsigned and small integer types to PostgreSQL.
Data Types
| Type | Description | Range |
|---|---|---|
int1 |
Signed 8-bit integer | -128 to 127 |
uint1 |
Unsigned 8-bit integer | 0 to 255 |
uint2 |
Unsigned 16-bit integer | 0 to 65535 |
uint4 |
Unsigned 32-bit integer | 0 to 4294967295 |
uint8 |
Unsigned 64-bit integer | 0 to 18446744073709551615 |
Usage
Operators and Functions
All types include a full set of arithmetic operators (+, -, *, /, %), comparison operators (=, <>, <, >, <=, >=), and operators for each combination of types. Standard aggregate functions and index support (btree, hash) are also provided.