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

Re: Numeric 508 datatype

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Numeric 508 datatype
Date: 2005-12-02 17:43:28
Message-ID: 3885.1133545408@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> So we are really decreasing the specified precision from 1000 to 508,
> and the computational precision from 4096 to 508.

The internal computational precision isn't any less, the limit is only
on the result of a function (ie, partial results within one of the
numeric.c routines could still exceed 10^508).  Not sure how much that
distinction matters though.

> Is there any plan to
> fix the silent overflow problem?  Is that in the patch?  I don't see it.

It will get fixed before application ;-)

I haven't reviewed the patch yet; I think the gating factor at this
point is whether anyone protests losing dynamic range in NUMERIC,
and we ought to go ahead and ask that.  After that we can look at the
code more closely.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-12-02 18:03:26
Subject: Re: Numeric 508 datatype
Previous:From: Bruce MomjianDate: 2005-12-02 17:39:11
Subject: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

pgsql-patches by date

Next:From: Julio C├ęsar ElizondoDate: 2005-12-02 17:50:29
Subject: unsuscribe patches
Previous:From: Bruce MomjianDate: 2005-12-02 17:39:11
Subject: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

pgsql-general by date

Next:From: Toni CasuepsDate: 2005-12-02 17:44:36
Subject: accessing text of the query in a rule
Previous:From: Bruce MomjianDate: 2005-12-02 17:39:11
Subject: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

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