Re: Allow the "operand" input of width_bucket() to be NaN

On Sat, 21 Jun 2025 at 22:21, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> The attached patch does what was discussed in the pgsql-docs
> thread at [1], namely change the four-argument variants of
> width_bucket() to allow their first argument to be NaN,
> treating that value as larger than any non-NaN.
>

LGTM.

I note that there is no doc update, and I think that is correct, since
we never previously documented that NaN wasn't allowed. The new
behaviour is what one would have expected, given that we do document
that NaN values compare as greater than all non-NaN values.

It could even be argued that this is a bug fix, but the lack of prior
complaints justifies not back-patching.

Regards,
Dean