In PostgreSQL, you can perform a variety of mathematical operations via built-in math functions, such as POWER(), SQRT(), etc. All these functions fulfill different tasks, for instance, finding the power of a number, the square root of a number, and so on. Similarly, PostgreSQL offers another convenient mathematical function named the **CEIL()** that rounds up a number to the next whole number.

This blog post will demonstrate the working of the **CEIL()** function via practical examples. So, let’s get started.

**How to Use CEIL() Function in Postgres?**

Postgres **CEIL()** function is one of the mathematical functions that take a numeric value or an expression as an argument and round up the given value/expression to the next whole number:

CEIL(arg_1);

- The above snippet shows that the
**CEIL()**function accepts only a single argument, “arg_1”. - The “arg_1” can be a numeric value or an expression.
- The retrieved value will have the same data type as the given numeric value/expression.

**Example 1: How Does the CEIL() Function Work?**

Let’s pass a numeric value to the CEIL() function and see how it works in Postgres:

SELECT CEIL(112.1232);

In the above snippet, the CEIL() function takes the number “112.1232”, and consequently, it retrieves the following output:

The output shows that the CEIL() function rounded up the given number to the nearest integer.

**Example 2: How Does the CEIL() Function Work With an Expression?**

Let’s pass an expression instead of a number to the CEIL() function and see how it works:

SELECT CEIL(572.272 + 168.278);

The output shows that the CEIL() function calculates the given expression and rounds the resultant value up to the nearest whole number.

**Example 3: How to Use the CEIL() Function on Table’s Data?**

We have already created an “emp_bio” table; let’s verify the selected table’s data via the SELECT command:

SELECT * FROM emp_bio;

Now let’s utilize the CEIL() function on the emp_sal column of the emp_bio table:

SELECT CEIL(emp_sal) FROM emp_bio;

The output authenticates the working of the CEIL() function as it successfully rounded up the column’s values to the nearest integers.

**Conclusion**

Postgres provides a **CEIL()** function that takes a numeric value or an expression as an argument and rounds up the given value/expression to the next whole number. The retrieved value will have the same data type as the given numeric value/expression. This blog post presented a detailed guide on the **CEIL()** function via practical examples.