> > > What do you see as the driver for having the field be a column type? Have > you looked into H2 function support? >
Hi Matt, Mostly just selfish reasons, but I do think there is a sound engineering/computer science basis for having another numeric type. Decimal types are arbitrary for computation, and we allow unlimited precision for decimal numbers (I guess in practice they round before too long). It is to avoid unnecessary rounding and wrinkles. I do think we tend to paper over these kind of issues in our industry and as a consequence end up with mediocre standards such as SQL. The strength of 'SQL' databases is the relational model not SQL. In anycase virtually all databases don't conform and have their own superset of functionality. - mike -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAOZwqwnhFnB8-Zny1CcK4G%2By3wduZWkMR%3DOC3ybvLSrag8kS5g%40mail.gmail.com.
