Re: BUG #16901: log(1, anyvalue) gives division by zero error

From: Samuel Woodward <samuelwoodward(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16901: log(1, anyvalue) gives division by zero error
Date: 2021-02-26 18:14:58
Message-ID: CANkLYxDQhGTH80919=8UoGBnVBCQReN6Z7iau3ugakemukfQPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Doh.. 🤦‍♂️

On Fri, 26 Feb 2021, 16:55 Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> > for example log(1, 10) gives division by zero error whereas log10(1)
> gives 0
>
> I think you have the arguments backwards: the equivalent
> computation is log(10, 1) not log(1, 10).
>
> regards, tom lane
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pantelis Theodosiou 2021-02-26 21:20:47 Re: BUG #16900: SELECT MAX subquery not allowed in WHERE clause when using WITH RECURSIVE
Previous Message Tom Lane 2021-02-26 16:55:56 Re: BUG #16901: log(1, anyvalue) gives division by zero error