Re: [HACKERS] bug in numeric_power() function

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-patches(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Richard Wang <ruc_wang(at)hotmail(dot)com>
Subject: Re: [HACKERS] bug in numeric_power() function
Date: 2008-05-07 22:22:03
Message-ID: 200805080022.04016.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > I have developed the attached patch which fixes 0 ^ 123.3.
>
> Did you actually read the wikipedia entry you cited?

Considering that 0::float8 ^ 0::float8 yields 1, making the numeric operator
do the same might not be completely unreasonable, but I find the rationale
that it is better for discrete mathematics fairly ludicrous on multiple
levels.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-05-07 22:22:05 Re: [HACKERS] bug in numeric_power() function
Previous Message David Fetter 2008-05-07 22:04:49 Auto-updated fields

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2008-05-07 22:22:05 Re: [HACKERS] bug in numeric_power() function
Previous Message Greg Smith 2008-05-07 22:07:07 Re: [GENERAL] pgbench not setting scale size correctly?