↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / Mathematical Functions And Operators

width_bucket

Read the PG 18 manual

Returns the number of the bucket in which operand falls in a histogram having count equal-width buckets spanning the range low to high.

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

width_bucket ( operand numeric, low numeric, high numeric, count integer ) → integer
Returns the number of the bucket in which operand falls in a histogram having count equal-width buckets spanning the range low to high. The buckets have inclusive lower bounds and exclusive upper bounds. Returns 0 for an input less than low, or count+1 for an input greater than or equal to high. If low > high, the behavior is mirror-reversed, with bucket 1 now being the one just below low, and the inclusive bounds now being on the upper side.
width_bucket(5.35, 0.024, 10.06, 5) → 3
width_bucket(9, 10, 0, 10) → 2
width_bucket ( operand double precision, low double precision, high double precision, count integer ) → integer
Returns the number of the bucket in which operand falls in a histogram having count equal-width buckets spanning the range low to high. The buckets have inclusive lower bounds and exclusive upper bounds. Returns 0 for an input less than low, or count+1 for an input greater than or equal to high. If low > high, the behavior is mirror-reversed, with bucket 1 now being the one just below low, and the inclusive bounds now being on the upper side.
width_bucket(5.35, 0.024, 10.06, 5) → 3
width_bucket(9, 10, 0, 10) → 2
width_bucket ( operand anycompatible, thresholds anycompatiblearray ) → integer
Returns the number of the bucket in which operand falls given an array listing the inclusive lower bounds of the buckets. Returns 0 for an input less than the first lower bound. operand and the array elements can be of any type having standard comparison operators. The thresholds array must be sorted, smallest first, or unexpected results will be obtained.
width_bucket(now(), array['yesterday', 'today', 'tomorrow']::timestamptz[]) → 2
Version history 7
  1. 13 → 14 changed
  2. 12 → 13 changed
  3. 9.4 → 9.5 changed
  4. 8.2 → 8.3 changed
  5. 8.1 → 8.2 changed
  6. 8.0 → 8.1 changed
  7. 7.4 → 8.0 added

Definition snapshot: b7bd9cda · English manual source