Re: BUG #19811: numeric log(base, x): wrong sign of Infinity result when base < 1; base 1 accepted with x = Infinity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 303677365(at)qq(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19811: numeric log(base, x): wrong sign of Infinity result when base < 1; base 1 accepted with x = Infinity
Date: 2026-10-30 21:36:52
Message-ID: 2753325.1793396212@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> The two-argument numeric logarithm returns +Infinity for x = Infinity
> regardless of the base. For bases between 0 and 1 the correct result is
> -Infinity, and for base 1 the call should be rejected.

Thanks for the report, but this was already reported and fixed
a couple weeks ago:

https://git.postgresql.org/gitweb/?a=commitdiff&h=94e1385ed&p=postgresql.git

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2026-10-30 21:41:46 Re: BUG #19809: oidvector index dedup still returns wrong results on 18.6; CTAS persists the corrupted rows
Previous Message Andrey Rachitskiy 2026-10-30 21:36:38 Re: BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86)