RE: Problems with function sum() on float values

2001-12-13 Thread Almar van Pel
-+ | 4.94 | +--+ 1 row in set (0.00 sec) ==>> >> FLOAT (10,2) Regards, Almar van Pel -Oorspronkelijk bericht- Van: M. A. Alves [mailto:[EMAIL PROTECTED]] Verzonden: donderdag, december 13, 2001 16.47 Aan: Wojciech Dr¹¿ek CC: [EMAIL PROTECTED] Onderwerp: Re:

Re: Problems with function sum() on float values

2001-12-13 Thread M. A. Alves
On Thu, 13 Dec 2001, [iso-8859-2] Wojciech Dr±¿ek wrote: > > I wonder if it is only question of configuration but my MySQL server has > problems with suming of float values. > > create table ft (id INT AUTO_INCREMENT, val FLOAT, PRIMARY KEY(id)); > insert ft(val) values('3.4'); > insert ft(val) va

Re: Problems with function sum() on float values

2001-12-13 Thread Kevin Smith
ow in set (0.02 sec) mysql> select version(); ++ | version() | ++ | 3.23.45-nt | ++ 1 row in set (0.00 sec) Regards, Kevin - Original Message - From: "Wojciech Drążek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 13, 20

Problems with function sum() on float values

2001-12-13 Thread Wojciech Drążek
I wonder if it is only question of configuration but my MySQL server has problems with suming of float values. Look at that script: # mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) # -- create table ft (id INT AUTO_INCREMENT, val FLOAT, PRIMARY KEY(id)); insert