> Now i see they are working. I made a mistake when testing. I was
> using truncate(2.111, 2), thinking the function have a second
> parameter to specify the precision.
>
> Just for curiosity, how do you truncate numbers to a specif number
> of decimal digits?
>
> Something like this?
> cast(truncate(2.111 * 100) as double precision) / 100
>

There's an F_FIXEDPOINT UDF to do this
Alan