| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Numeric 508 datatype |
| Date: | 2005-12-02 21:01:32 |
| Message-ID: | 1133557292.2906.640.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-patches |
On Fri, 2005-12-02 at 14:09 -0500, Bruce Momjian wrote:
> I ran your SELECT pow(10::numeric, 131071), and gain, 4096 0's are
> displayed on my screen. SELECT pow(10::numeric, 7000) and SELECT
> pow(10::numeric, 10000) generate identical displays on my screen.
Are you saying there is a bug with or without my patch?
Can we get the usual release levels/cvstip, ports, etc.
Are you connecting across network/ protocol differences...
[Just out of interest, has anybody ever used a number bigger than 10^20
in an application? My understanding is that the number of atoms in the
universe is around 10^80. Accuracy is needed during calculation, but
much less so during storage.]
Thanks,
Best Regards, Simon Riggs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-02 21:02:23 | Re: Adding order bys to the view definitions (7.4) |
| Previous Message | Bruce Momjian | 2005-12-02 20:59:36 | Re: Numeric 508 datatype |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Maxwell | 2005-12-02 21:01:39 | Re: Reducing relation locking overhead |
| Previous Message | Bruce Momjian | 2005-12-02 20:59:36 | Re: Numeric 508 datatype |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-12-02 21:05:28 | Re: Numeric 508 datatype |
| Previous Message | Bruce Momjian | 2005-12-02 20:59:36 | Re: Numeric 508 datatype |