Skip site navigation (1) Skip section navigation (2)

Re: Numeric 508 datatype

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-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



In response to

Responses

pgsql-hackers by date

Next:From: Gregory MaxwellDate: 2005-12-02 21:01:39
Subject: Re: Reducing relation locking overhead
Previous:From: Bruce MomjianDate: 2005-12-02 20:59:36
Subject: Re: Numeric 508 datatype

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-12-02 21:05:28
Subject: Re: Numeric 508 datatype
Previous:From: Bruce MomjianDate: 2005-12-02 20:59:36
Subject: Re: Numeric 508 datatype

pgsql-general by date

Next:From: Tom LaneDate: 2005-12-02 21:02:23
Subject: Re: Adding order bys to the view definitions (7.4)
Previous:From: Bruce MomjianDate: 2005-12-02 20:59:36
Subject: Re: Numeric 508 datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group