uint128

pg_uint128 : Native uint128 type

Overview

Packages

Source

pig build pkg pg_uint128;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

pig install pg_uint128;		# install via package name, for the active PG version
pig install uint128;		# install by extension name, for the current active PG version

pig install uint128 -v 18;   # install for PG 18
pig install uint128 -v 17;   # install for PG 17
pig install uint128 -v 16;   # install for PG 16
pig install uint128 -v 15;   # install for PG 15
pig install uint128 -v 14;   # install for PG 14

Create this extension with:

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