pgmp 1.0.0-b3

This Release
pgmp 1.0.0-b3
Date
Status
Testing
Latest Stable
pgmp 1.0.5 —
Other Releases
Abstract
PostgreSQL Multiple Precision Arithmetic extension
Description
The pgmp extension adds PostgreSQL data types wrapping the high performance integer and rational data types offered by the GMP library.
Released By
piro
License
LGPL 3.0
Resources
Special Files
Tags

Extensions

pgmp 1.0.0-b3
PostgreSQL Multiple Precision Arithmetic extension

Documentation

genindex
Index — PostgreSQL Multiple Precision Arithmetic 1.0 documentation
misc
Miscellaneous functions
mpz
mpz data type — PostgreSQL Multiple Precision Arithmetic 1.0 documentation
mpq
mpq data type — PostgreSQL Multiple Precision Arithmetic 1.0 documentation
misc
Miscellaneous functions — PostgreSQL Multiple Precision Arithmetic 1.0 documentation
search
Search — PostgreSQL Multiple Precision Arithmetic 1.0 documentation
install
pgmp extension installation — PostgreSQL Multiple Precision Arithmetic 1.0 documentation
mpq
!mpq data type
index
PostgreSQL Multiple Precision Arithmetic
install
!pgmp extension installation
index
PostgreSQL Multiple Precision Arithmetic — PostgreSQL Multiple Precision Arithmetic 1.0 documentation
mpz
!mpz data type

README

PostgreSQL Multiple Precision Arithmetic extension

pgmp is a PostgreSQL extension module to add support for the arbitrary precision data types offered by the GMP library into the database.

The extension adds the types mpz (arbitrary size integers) and mpq (arbitrary precision rationals) to PostgreSQL and exposes to the database all the functions available in the GMP library for these types, providing:

  • higher performance arithmetic on integers respect to the decimal data type, using numbers only limited by the 1GB varlena maximum size;
  • a rational data type for absolute precision storage and arithmetic;
  • the use of specialized functions to deal with prime numbers, random numbers, factorization directly into the database.

The GMP data types can be stored into the database, used in mixed arithmetic with other PostgreSQL numeric types and indexed using the btree or hash methods.

The extension is compatible with PostgreSQL versions from 8.4 and packaged as a SQL extension in 9.1. The package includes comprehensive documentation and regression tests.

Please refer to the documentation for installation and usage, either online or in the docs/ directory.