Luis Madaleno wrote:

> But I am always multiplying by 1.
> Since fld2 is always 1 (in my tests):
>
> new.fld3 = new.fld1 * 1;
> this shouldn't return any error;
>
> But should NUMERIC(18,6) allow for bigger values?
>
> Luis
>

Hello,

No matter that you multiply by 1, fld2 is declared as NUMERIC(18,6) so
the result is will be NUMERIC(18,12);
Use CAST as NUMERIC(18,6)

HTH
Radu