Functions / Mathematical Functions And Operators
Greatest common divisor (the largest positive number that divides both inputs with no remainder); returns 0 if both inputs are zero; available for integer, bigint, and numeric
Reading PG 18current·documented in 8 of 27 versions, 13 to 20
gcd ( numeric_type, numeric_type ) → numeric_typeGreatest common divisor (the largest positive number that divides both inputs with no remainder); returns
0 if both inputs are zero; available for integer, bigint, and numericgcd(1071, 462) → 21
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source