On Fri, Mar 11, 2011 at 11:36:14AM +0000, Gianni Ciolli wrote:
> maybe we should change the "1000 digits" here:
> 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.
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2011-03-21 01:05:48|
|Subject: Re: Sync Rep and shutdown Re: Sync Rep v19|
|Previous:||From: Jan Urbański||Date: 2011-03-20 23:40:02|
|Subject: pl/python tracebacks v2|