Re: Numeric 508 datatype - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Numeric 508 datatype
Date
Msg-id 1133557292.2906.640.camel@localhost.localdomain
Whole thread Raw
In response to Re: Numeric 508 datatype  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Numeric 508 datatype
List 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



pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Numeric 508 datatype
Next
From: Bruce Momjian
Date:
Subject: Re: Numeric 508 datatype