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
>
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 |
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 |