You could probably create a before insert trigger which compares the number of
fractional digits in the given number with the defined scale (surely some
system table can offer you that) and raises an exception if needed. I do agree
though with Niklas Johansson's remarks and wonder with him on wh
On 15 feb 2008, at 08.28, Horst Dehmer wrote:
Is there an easy way to enforce strict handling of numeric values
with scales, i.e. raise an exception/error instead of rounding
values to the specified scale?
insert into dummy values(3.141); -- insert #1
insert into dummy values(3.1415); --
On Fri, Feb 15, 2008 at 1:28 AM, Horst Dehmer <[EMAIL PROTECTED]> wrote:
>
>
> Hi!
>
> Is there an easy way to enforce strict handling of numeric values with
> scales, i.e. raise an exception/error instead of rounding values to the
> specified scale?
I can't think of an easy way. But you can alwa
Hi!
Is there an easy way to enforce strict handling of numeric values with
scales, i.e. raise an exception/error instead of rounding values to the
specified scale?
In a given schema with 250+ tables I have lots of numeric columns with a
scale > 0. The docs (chapter 8.1.2) state clearly that gre
