CEILING Function - SQL Server to PostgreSQL Migration

In SQL Server and PostgreSQL, the CEILING function rounds up the specified number to the nearest integer value.

SQL Server and PostgreSQL:

  -- Round to the nearest larger integer 
  SELECT CEILING(123.7);
  /* 124 */  
 
  -- Still rounds to larger integer even if it is closer to smaller integer
  SELECT CEILING(123.1);
  /* 124 */

For more information, see SQL Server to PostgreSQL Migration.