On 9/29/05, Darren Duncan <[EMAIL PROTECTED]> wrote: > > At 11:07 AM -0600 9/29/05, Dennis Cote wrote: > >As you can see, the result of exact (integer) division is also exact > >(integer) with implementation defined precision and scale. The > >result of an expression containing approximate (floating point) > >values is approximate (floating point). So SQLite is conforming to > >the SQL standard. > > You mis-understand what 'exact' means; 'exact' != 'integer', but > rather 'integer is conceptually a sub-set of exact. An exact value > can be fractional, such as '1.32', and yet not be floating point.
True mathematically but not in practice. All fractional numbers are represented as floating point, therefore there are no exact fractional numbers on any SQL implementations I am aware of. It's possible to do, but I've never seen it done.
