Skip to content
PostgreSQL Multiple Precision Arithmetic extension
C Python C++ TSQL Makefile PLpgSQL Shell
Branch: master
Clone or download

Latest commit

Fetching latest commit…
Cannot retrieve the latest commit at this time.

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github
bench
docs
sandbox
sql
src
test
tools
.gitignore
.travis.yml
AUTHORS
COPYING
META.json
Makefile
NEWS.rst
README.rst
pgmp.control

README.rst

PostgreSQL Multiple Precision Arithmetic extension

Build status

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.

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

You can’t perform that action at this time.