Extensions / Functions and aggregates
Computes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm.
pgext.cloud · Source code · Documentation · Control file
| Package | pg_calcpi |
|---|---|
| Version | 1.0 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 1 |
| Latest commit | 2021-03-23 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| gcd | C function that computes the greatest common divisor of an integer array. |
| numpgsql | Array and numerical computing library for PostgreSQL |
| cmath | C11 math functions exposed to PostgreSQL with C-backed implementations. |
| graph_component | Compute graph components |
| complex | Complex-number data type for PostgreSQL. |
| eigen | New array types and linear-algebra functions based on the Eigen numerical template library. |
| sum_array | C function that sums PostgreSQL integer and floating-point arrays into float8. |
| fbsql | Closure-preserving formula-based statistical modeling in SQL |