On Fri, Feb 28, 2025 at 7:15 AM Ben Peachey Higdon <bpeacheyhig...@gmail.com> wrote: > The current documentation for width_bucket > (https://www.postgresql.org/docs/current/functions-math.html) does not > mention if the range’s low and high are inclusive or exclusive. > > Returns the number of the bucket in which operand falls in a histogram having > count equal-width buckets spanning the range low to high. Returns 0 or > count+1 for an input outside that range. > > I had assumed that both the low and high were inclusive but actually the low > is inclusive while the high is exclusive. >
I'm not sure it's the most ground breaking thing, but would probably save a bunch of future people from having to gin up an example to test it, so I'd probably update it per the following patch. Robert Treat https://xzilla.net
v1-0001-Document-width_bucket-range-as-inclusive-exclusiv.patch
Description: Binary data