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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
