postgresql-17-rational

Precise fractional arithmetic for PostgreSQL

Description

pg_rational implements precise fractional arithmetic for PostgreSQL. Perfect for exact arithmetic or user-specified table row ordering. Holds values as big as an integer, with matching precision in the denominator.

Features:
 * Stores fractions in exactly 64 bits (same size as float)
 * Written in C for high performance
 * Detects and halts arithmetic overflow for correctness
 * Uses native CPU instructions for fast overflow detection
 * Defers GCD calculation until requested or absolutely required
 * Supports btree and hash indices
 * Implements Stern-Brocot trees for finding intermediate points
 * Coercion from integer/bigint/tuple
 * Custom aggregate

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Upload a screenshot

Hint: upload an image here from your clipboard with Ctrl-V


Homepage

https://github.com/begriffs/pg_rational


Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…

Install postgresql-17-rational