↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / Mathematical Functions And Operators

ceiling

Read the PG 18 manual

Nearest integer greater than or equal to argument (same as ceil)

Reading PG 18current·documented in 23 of 27 versions, 8.0 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

ceiling ( numeric ) → numeric
Nearest integer greater than or equal to argument (same as ceil)
ceiling(95.3) → 96
ceiling ( double precision ) → double precision
Nearest integer greater than or equal to argument (same as ceil)
ceiling(95.3) → 96
Version history 3
  1. 12 → 13 changed
  2. 9.0 → 9.1 changed
  3. 7.4 → 8.0 added

Definition snapshot: b7bd9cda · English manual source