Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wdue6-004QhN-1x for pgsql-bugs@arkaria.postgresql.org; Sun, 28 Jun 2026 18:54:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wdue4-00H8In-3C for pgsql-bugs@arkaria.postgresql.org; Sun, 28 Jun 2026 18:54:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wdue4-00H8If-20 for pgsql-bugs@lists.postgresql.org; Sun, 28 Jun 2026 18:54:20 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wdue1-00000000e6Q-2RaQ for pgsql-bugs@lists.postgresql.org; Sun, 28 Jun 2026 18:54:19 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id A3ED95E8A0D for ; Sun, 28 Jun 2026 20:54:13 +0200 (CEST) Received: from s979.loopia.se (unknown [172.22.191.6]) by s807.loopia.se (Postfix) with ESMTP id 90B805E8809; Sun, 28 Jun 2026 20:54:13 +0200 (CEST) Received: from localhost (unknown [172.22.191.6]) by s979.loopia.se (Postfix) with ESMTP id 8F73D10BC449; Sun, 28 Jun 2026 20:54:13 +0200 (CEST) X-Virus-Scanned: amavis at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.2 X-Spam-Level: X-Spam-Status: No, score=-1.2 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1] autolearn=disabled Authentication-Results: s470.loopia.se (amavis); dkim=pass (2048-bit key) header.d=yesql.se Received: from s981.loopia.se ([172.22.191.5]) by localhost (s470.loopia.se [172.22.190.34]) (amavis, port 10024) with LMTP id pQKtcesybuQE; Sun, 28 Jun 2026 20:54:13 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: IPv6:2001:2043:5ad6:9500:810c:69f0:29dd:8d6c Received: from smtpclient.apple (unknown [IPv6:2001:2043:5ad6:9500:810c:69f0:29dd:8d6c]) (Authenticated sender: daniel@yesql.se) by s981.loopia.se (Postfix) with ESMTPSA id 1EB4022B1760; Sun, 28 Jun 2026 20:54:13 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yesql.se; s=loopiadkim1707475645; t=1782672853; bh=xRj3us9Qe+DkzDvyXdiRonCz07iLuWjdD4cgtn5bjfQ=; h=Subject:From:In-Reply-To:Date:Cc:References:To; b=o0i7HpJmu2NXjf8zwk9wtX0tYbNfrHa9Y6ar5K5alMMe7/FB/zUG8hOkH5XTUNura WROA+4EqkoNaUp6ZuCWBPfDpWWPL0g3kufxjSuzI/K4SwC7GQOfnlDMHuuZZFBxdOG KjGk9O63mr9J28lHtWYffcAKf8g9zYZeOV80rr1lKrjYCEDXXlt0zzu09eqk9NP980 LEI8+1NNMqvN9R9Ow2kMCIDChaD+W8LvFWeB9vlrCCrlAkcXuA8nOkJCZpvIWYrpFe z0zmgJ1Jl6qlf+CZU+yTGg5qWKIroiPoOCQsTsghUrfBDwa6eMhlFMedOrzltPrzpD qXS+brW78Q05A== Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.12\)) Subject: Re: BUG #19524: NaN handling in btree_gist's float4/float8 opclasses From: Daniel Gustafsson In-Reply-To: Date: Sun, 28 Jun 2026 20:54:02 +0200 Cc: pgsql-bugs@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Bill Kim X-Mailer: Apple Mail (2.3776.700.51.11.12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 28 Jun 2026, at 04:14, Bill Kim wrote: >=20 > Hi all, >=20 > I have a patch for this and `make check` passes (core + all contrib, = plus > new btree_gist NaN cases covering the three scenarios in the = report). > Posting here first in case someone is already further along =E2=80=94 = if not, > I'll send it to pgsql-hackers and register it in the open CF in a = couple > of days. Even if someone else is working on it, always feel free to send your = patch. Multiple implementations of a fix is not a problem but an opportunity = for everyone to learn from each other. -- Daniel Gustafsson