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?
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > How do intend to treat 5/2 if passed to an Sqlite function expecting
> > an integer argument?
>
> Exactly the same thing that happens now if you pass 2.5
> into that same function: it truncates the value to an
> integer 2.
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
>
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
