On Wed, Mar 23, 2005 at 04:13:22PM -0500, 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.
That assumption is wrong. There is no default. -- Alvaro Herrera (<[EMAIL PROTECTED]>) "La primera ley de las demostraciones en vivo es: no trate de usar el sistema. Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
