Functions / Mathematical Functions And Operators
Least common multiple (the smallest strictly positive number that is an integral multiple of both inputs); returns 0 if either input is zero; available for integer, bigint, and numeric
Reading PG 18current·documented in 8 of 27 versions, 13 to 20
lcm ( numeric_type, numeric_type ) → numeric_typeLeast common multiple (the smallest strictly positive number that is an integral multiple of both inputs); returns
0 if either input is zero; available for integer, bigint, and numericlcm(1071, 462) → 23562
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source