Hi, > I am sure, that I will not be able to modify these queries.
If you write code that only works with Oracle and no other database, then well, you need to use Oracle. It seems only Oracle works they way you want it, and no other database I have tested (PostgreSQL, Apache Derby, HSQLDB, H2). It is not my plan to make H2 100% compatible with Oracle. If you know that you want to calculate with a given precision, you should use that precision in the calculation. In your case that seems to be (1.0 - ?) and not (1 - ?). That way the database knows it's a decimal when compiling (preparing) the statement. Regards, Thomas -- 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.
