Re: Reducing NUMERIC size for 8.3 - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Reducing NUMERIC size for 8.3
Date
Msg-id 1182182031.6855.205.camel@silverbirch.site
Whole thread Raw
In response to Re: Reducing NUMERIC size for 8.3  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
On Mon, 2007-06-18 at 17:49 +0200, Andreas Pflug wrote:

> I wonder if the currently waiting patch isn't Good Enough for
> 999.9999999999999999 % of use cases, and "all" others can use numeric
> instead of numeric(1000,800) or so. Especially since there are many
> patches waiting that do need further investigation and refining.

That still has problems.

Another approach would be to restrict the existing datatype NUMERIC to
508 digits, but introduce a new datatype of LONGNUM which allows
arbitrary length numerics for those that *do* care. It might be more
beneficial in the longer run to separate the use cases so we can further
tune them (not sure how just yet...)

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reducing NUMERIC size for 8.3
Next
From: "Simon Riggs"
Date:
Subject: Re: Reducing NUMERIC size for 8.3