On Wed, 23 Mar 2005, Sergio Lob wrote:
> Precision is the number of total digits in the number. Scale is the
> number of fractional digits.
> For instance, a column defined as NUMERIC(10,3) should return
> precision=10, scale=3. The error only occurs for a column defined as
> NUMERIC (without precision or scale specified). Presumably, there is a
> default precision and scale assigned to the column by postgreSQL, which
> is not -1.
IIRC, there is not a default precision and scale assigned to the column.
It's treated as having an unspecified precision and scale.
In response to
pgsql-bugs by date
|Next:||From: Andrew - Supernews||Date: 2005-03-23 21:26:55|
|Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1|
|Previous:||From: Alvaro Herrera||Date: 2005-03-23 21:25:05|
|Subject: Re: Precision and scale of numeric column reported as value|