Hello,
It seems I have a problem :(( I can't get TRUNC function to work expected.
TRUNC only seems to work when the second parameter does not come from
database (e.g. TRUNC(measurement, 2) works perfectly well). If it's comes
from a table, then it returns the original parameter instead of truncated
one.
I also tried to create a function, however, it does not work as expected as
well.
CREATE DBFUNCTION trunc_measurement (measurement FIXED(14,7), precision_id
INT) RETURNS NUMBER AS
TRY
RETURN TRUNC(measurement, precision_id);
CATCH
RETURN NULL;
Is there anything I could do to get it working? Or am I - as it usual
happens :) - missing something?
Thanks,
Andris
P.S.
I am using MaxDB 7.5.05
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
