CEILING

A synonym for CEIL: returns a number rounded up to the nearest integer.

PostgreSQL 17.9

CEILING(num)

Return value

A whole value: numeric for numeric, double precision for double precision and for an integer argument

PostgreSQL 17.9

SELECT CEILING(4.1) AS up,
	CEILING(-4.1) AS negative;

up	negative
5	-4

PostgreSQL 17.9

SELECT good,
	SUM(amount) AS units,
	CEILING(SUM(amount) / 3.0) AS boxes_of_three
FROM Payments
GROUP BY good
ORDER BY good;

CEILING and CEIL work the same. Negative numbers are rounded towards zero: CEILING(-4.1) returns -4.