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
