Re: [SQLObject] DecimalCol

[Oleg B. <ph...@ma...>]

On Mon, Dec 06, 2004 at 03:53:47PM -0600, Ian Bicking wrote:
> >DecimalCol it's probably a bug, but that's another story.
>
> No, it's required for DecimalCol -- databases require size and
> precision.  At least, the ones I know of do...?  There's no default for

   MySQL, I suppose? :)

> size, hence the assertion.

   Postgres 7.2:

"Both the precision and the scale of the numeric type can be configured.
To declare a column of type numeric use the syntax

 NUMERIC(precision, scale)

   The precision must be positive, the scale zero or positive.
Alternatively,

 NUMERIC(precision)

   selects a scale of 0. Specifying

 NUMERIC

   without any precision or scale creates a column in which numeric
values of any precision and scale can be stored, up to the
implementation limit on precision. A column of this kind will not coerce
input values to any particular scale, whereas numeric columns with a
declared scale will coerce input values to that scale."

Oleg.
--
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.