pg_math

pig build pkg pg_math;		# build rpm/deb

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

pig install pg_math;		# install via package name, for the active PG version

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

CREATE EXTENSION pg_math;

CREATE EXTENSION pg_math;

-- Gaussian distribution
SELECT rdf_gaussian(1.5, 2.0);            -- PDF at x=1.5, sigma=2.0
SELECT cdf_gaussian_p(1.5, 2.0);          -- CDF P-value

-- Unit Gaussian (standard normal)
SELECT cdf_unit_gaussian_p(1.96);          -- ~0.975

-- Chi-squared distribution
SELECT cdf_chisq_p(3.84, 1.0);            -- ~0.95

-- T-distribution
SELECT cdf_tdist_pinv(0.975, 10.0);       -- critical value for 95% CI with df=10

-- Poisson distribution
SELECT rdf_poisson(5, 3.0);               -- P(X=5) with lambda=3

-- Beta distribution
SELECT rdf_beta(0.5, 2.0, 5.0);           -- PDF at x=0.5, a=2, b=5