Re: BUG #19524: NaN handling in btree_gist's float4/float8 opclasses

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Kim <billkimjh(at)gmail(dot)com>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19524: NaN handling in btree_gist's float4/float8 opclasses
Date: 2026-06-29 15:35:10
Message-ID: 1717564.1782747310@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Bill Kim <billkimjh(at)gmail(dot)com> writes:
> missed the file and please refer to attached.

OK, thanks. I didn't go over this in detail yet, but at first
glance it looks reasonable.

What I am wondering right now is whether it's better to back-patch
this or leave well enough alone. Given that we've now had two
independent complaints, maybe there are enough people using btree_gist
with NaNs to justify a back-patch, even though it'd force them to
reindex.

In any case, sneaking it into v19 seems reasonable.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bill Kim 2026-06-29 15:50:11 Re: BUG #19524: NaN handling in btree_gist's float4/float8 opclasses
Previous Message Bill Kim 2026-06-29 15:27:21 Re: BUG #19524: NaN handling in btree_gist's float4/float8 opclasses