List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 15 1999 2:57am
Subject:Re: request
View as plain text  
At 2:49 AM -0400 8/15/99, Paradox wrote:
>They lose accuracy when adding up thousands of values.


Do you mean DECIMAL or FLOAT, or both?  DECIMAL shouldn't lose any
accuracy.



>----- Original Message -----
>From: Tonu Samuel <tonu@stripped>
>To: Paradox <paradox2@stripped>
>Cc: <mysql@stripped>; <developer@stripped>
>Sent: Saturday, August 14, 1999 9:49 AM
>Subject: Re: request
>
>
>> Paradox wrote:
>>
>> > I request that the developers of MySQL implement some sort of special
>type
>> > of field that can be used to store currency up to 4 digits precision
>> > (specified in field definition) exactly, using a BIGINT shifted a number
>of
>> > digits, so that it doesn't have to be stored unpacked and thus things
>like
>> > Sum() or ORDER BY go
>> > faster. (I assume when you order by or sum an unpacked decimal field you
>> > have to make a billion calls to strtol). This saves the trouble of
>having to
>> > do a billion *100, /100 in SQL statements, thanks.
>>
>>   But why the other type like DECIMAL or FLOAT don't work for you?
>>
>> --
>> +----------------------------------------------------------------+
>> | TcX  ____  __     _____   _____  ___                           |
>> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
>> |    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonu@stripped        |
>> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
>> |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
>> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
>> |             /*/             \*\                Developers Team |
>> +----------------------------------------------------------------+
>>
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>> posting. To request this thread, e-mail mysql-thread10203@stripped
>>
>> To unsubscribe, send a message to the address shown in the
>> List-Unsubscribe header of this message. If you cannot see it,
>> e-mail mysql-unsubscribe@stripped instead.
>>
>>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail developer-thread181@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail developer-unsubscribe@stripped instead.


-- 
Paul DuBois, paul@stripped
Thread
requestParadox14 Aug
  • Re: requestTonu Samuel14 Aug
    • Re: requestPaul DuBois14 Aug
  • Re: requestParadox15 Aug
    • Re: requestPaul DuBois15 Aug
  • Re: requestParadox15 Aug
  • Re: requestTonu Samuel15 Aug
  • Re: requestScott Hess16 Aug
  • Re: requestParadox16 Aug
    • Re: requestMichael Widenius21 Aug
RE: requestRichard Schilling16 Aug