PostgreSQL CEILING function.

Preamble

The PostgreSQL CEILING function returns the smallest integer value, which is greater than or equal to a number.

Syntax of the ceiling function in PostgreSQL

ceiling( number )

Parameters and function arguments

• number – The value used to search for the smallest integer value.

Note:

• The ceiling function is synonymous with the ceil function.

The ceiling function can be used in the following PostgreSQL versions

PostgreSQL 11, PostgreSQL 10, PostgreSQL 9.6, PostgreSQL 9.5, PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4.

Let’s look at some examples of the ceiling function to understand how to use the ceiling function in PostgreSQL.
For example:

SELECT ceiling(32.65);

--Result: 33

SELECT ceiling(32.1);

--Result: 33

SELECT ceiling(32);

--Result: 32

SELECT ceiling(-32.65);

--Result: -32

SELECT ceiling(-32.1);

--Result: -32

SELECT ceiling(-32);

--Result: -32

Tutorial; Creating Functions in PostgreSQL

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.