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