Re: [sqlite] round ?

2005-07-28 Thread Nicolas Martin
Oops, i didn't check cvstrack Many thanks ! Nicolas D. Richard Hipp wrote: On Thu, 2005-07-28 at 08:37 +0200, Nicolas Martin wrote: Some strange effect of the round expression : sqlite> select round(1-0.5); 0 sqlite> select round(2-0.5); 2 See http://www.sqlite.org/cvst

Re: [sqlite] round ?

2005-07-28 Thread Nicolas Martin
5); 4 sqlite> select round(5-0.5); 5 sqlite> select round(6-0.5); 6 Maybe the math libarary on the C compiler you are using? -Original Message----- From: Nicolas Martin [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 2:37 PM To: sqlite-users@sqlite.org Subject: [sqlite] round ? S

[sqlite] round ?

2005-07-27 Thread Nicolas Martin
Some strange effect of the round expression : sqlite> select round(1-0.5); 0 sqlite> select round(2-0.5); 2 sqlite> select round(3-0.5); 2 sqlite> select round(4-0.5); 4 sqlite> select round(5-0.5); 4 sqlite> select round(6-0.5); 6 sqlite>