Re: maximum digits for NUMERIC

On Fri, Mar 11, 2011 at 11:36:14AM +0000, Gianni Ciolli wrote:
> maybe we should change the "1000 digits" here:
> 
>   http://developer.postgresql.org/pgdocs/postgres/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
> 
> because ISTM that up to 2^17 digits are supported (which makes more
> sense than 1000).

Agreed.  The documentation is suggestive of this limit:

# CREATE TABLE n (c numeric(1001,0));
ERROR:  NUMERIC precision 1001 must be between 1 and 1000
LINE 1: CREATE TABLE n (c numeric(1001,0));

However, that's indeed just a limit of the numeric typmod representation, not
the data type itself.  An unqualified "numeric" column hits no such limit.