Joe Wilson <[EMAIL PROTECTED]> wrote: > I've found a potential problem - > round() is not a good substitute for the old integer truncation. > > Consider the previous Sqlite3 behavior: > > sqlite> select 15/8; > 1 > sqlite> select round(15.0/8.0); > 2 > > Can you recommend or provide a new function that performs correct > integer trunction? >
I think the current code in CVS allows you to do this with CAST( 15.0/8.0 AS integer ) But I admit I need to test that case more thoroughly. -- D. Richard Hipp <[EMAIL PROTECTED]>
