| 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: | Whole Thread | Raw Message | 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 |