|visits||member for||9 months|
|seen||Oct 4 '12 at 13:24|
According to the SQL92 spec, can I store the value 1 in a field where the precision = scale?
That is what we were thinking. We were confused when we were able to store the value 1 in a column like this in Firebird version 1.2 and version 2.5. This SQL returns 1 => SELECT CAST(1 AS DECIMAL(3,3)) FROM RDB$DATABASE