Horton

Re: Reducing NUMERIC size for 8.3

Simon Riggs <simon@2ndquadrant.com>

View thread View on postgr.es
From: "Simon Riggs" <simon@2ndquadrant.com>
To: "Andreas Pflug" <pgadmin@pse-consulting.de>
Cc: <pgsql-hackers@postgresql.org>
Date: 2007-06-18T15:19:01Z
Lists: pgsql-hackers 
On Mon, 2007-06-18 at 16:56 +0200, Andreas Pflug wrote:
> Simon Riggs wrote:
> > The objections to applying this patch originally were:
> > 2. it would restrict number of digits to 508 and there are allegedly
> > some people that want to store > 508 digits.
> >   
> If 508 digits are not enough, are1000 digits be sufficient? Both limits
> appear quite arbitrary to me.

Thats the current limit; I agree, but I didn't choose it. IIRC if you
don't specify a limit then you can have arbitrarily long numbers.

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