Re: bug in numeric_power() function

From: "Richard Wang" <ruc_wang(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bug in numeric_power() function
Date: 2008-03-14 01:25:57
Message-ID: frck80$2rcv$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

I also have a question here:
isn't dpow enough for calculation?
Why added numeric_power?
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> :12538(dot)1205298992(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "Richard Wang" <ruc_wang(at)hotmail(dot)com> writes:
>> I expected 0 ^ 123.3 to be 0, but it reported error as follows
>> postgres=# select 0 ^ 123.3;
>> ERROR: cannot take logarithm of zero
>
> Hmm, seems like the numeric and float8 power operators don't agree
> about 0^0 either...
>
> regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2008-03-14 02:06:45 PROC_VACUUM_FOR_WRAPAROUND doesn't work expectedly
Previous Message James Mansion 2008-03-13 22:14:18 Re: Proposal for db level triggers

Browse pgsql-patches by date

  From Date Subject
Next Message ITAGAKI Takahiro 2008-03-14 02:54:34 Suppress compiler warnings on mingw
Previous Message Robert Lor 2008-03-13 15:14:29 Re: DTrace probe patch for OS X Leopard