Horton

Re: maximum digits for NUMERIC

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gianni Ciolli <gianni.ciolli@2ndquadrant.it>
Cc: pgsql-hackers@postgresql.org
Date: 2011-03-11T14:38:03Z
Lists: pgsql-hackers 
Gianni Ciolli <gianni.ciolli@2ndquadrant.it> writes:
> 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

This is incorrect.  (You're confusing the number of stored digits
with the location of the decimal point.)

			regards, tom lane