uint128

Overview

breaks on el8 since 1.1 ,fix el8 build problem by adding __has_builtin marco

Version

Build

You can build the RPM / DEB packages for pg_uint128 using pig build:

pig build pkg pg_uint128         # build RPM / DEB packages

Install

You can install pg_uint128 directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

• Install
• pig
• dnf
• apt

pig install pg_uint128;          # Install for current active PG version

pig ext install -y pg_uint128 -v 18  # PG 18
pig ext install -y pg_uint128 -v 17  # PG 17
pig ext install -y pg_uint128 -v 16  # PG 16
pig ext install -y pg_uint128 -v 15  # PG 15
pig ext install -y pg_uint128 -v 14  # PG 14

dnf install -y pg_uint128_18       # PG 18
dnf install -y pg_uint128_17       # PG 17
dnf install -y pg_uint128_16       # PG 16
dnf install -y pg_uint128_15       # PG 15
dnf install -y pg_uint128_14       # PG 14

apt install -y postgresql-18-pg-uint128   # PG 18
apt install -y postgresql-17-pg-uint128   # PG 17
apt install -y postgresql-16-pg-uint128   # PG 16
apt install -y postgresql-15-pg-uint128   # PG 15
apt install -y postgresql-14-pg-uint128   # PG 14

Create Extension:

CREATE EXTENSION uint128;

Usage

uint128: unsigned 128-bit integer type for PostgreSQL

The uint128 extension provides comprehensive unsigned and 128-bit integer types with full operator and index support.

CREATE EXTENSION uint128;

Data Types

Operators

• Arithmetic: +, -, *, /, %
• Bitwise: # (XOR), & (AND), | (OR), ~ (NOT), << (left shift), >> (right shift)
• Comparison: =, <>, >, <, >=, <=

Mixed-type arithmetic between signed and unsigned types is supported.

Features

• Range types for all integer types (uint1range, uint16range, etc.) with GiST indexing
• Casts to/from numeric, real, double, uuid (uint16 only), json, jsonb
• Aggregate functions: SUM, AVG, MIN, MAX
• generate_series() support for all types
• Btree and hash index support
• Binary send/receive protocol support