The number of digits in the ROUND() function seems to be a mandatory argument in H2:
http://www.h2database.com/html/functions.html#round Many RDBMS (except SQL Server, Sybase, Ingres) make that an optional argument and allow for calling ROUND(X) = ROUND(X, 0): http://www.techonthenet.com/oracle/functions/round_nbr.php http://dev.mysql.com/doc/refman/5.5/en/mathematical-functions.html#function_round http://www.postgresql.org/docs/9.0/static/functions-math.html#FUNCTIONS-MATH-FUNC-TABLE That might be a nice compatibility enhancement... Cheers Lukas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
