ultiplies and
>sum.
>
>
It depends on why you're storing this information in the first place.
If what you want is the precision of fractions (which you lose with
floating point), then store the numerator and denominator. If you want
quick and dirty calculations at certain
the mathematics are wide open.
> _M
>
>I suspect that a float add is faster than 3 integer multiplies and
>sum.
Ah, but it is not as accurate!
If the original poster knows he needs fractions, he won't be happy with float.
Just as one should NEVER use floating point to represent mon
a float add is faster than 3 integer multiplies and
sum.
]-Original Message-
]From: MySQL [mailto:[EMAIL PROTECTED]]
]Sent: Thursday, September 19, 2002 7:51 PM
]To: [EMAIL PROTECTED]
]Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
]Subject: Re: Fractions
]
]
] Mailing-Li
PM
]To: [EMAIL PROTECTED]
]Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
]Subject: Re: Fractions
]
]
] Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
](http://www.ezmlm.org)
] X-Sender: [EMAIL PROTECTED]@teton.kitebird.com
] Date: Thu, 19 Sep 2002 08:54:55 -0500
] From: Paul DuBois
7 -0500 9/18/02, William Martell wrote:
>Hello.
>
>Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
>data representing different lengths of objects measured in inches. Can I
>load this data as is into a field in MySQL or do I have to convert it
[ this mysql spam filter sucks -- including a query in one's message
isn't good enough ]
[EMAIL PROTECTED] wrote:
>>you could store them as 3 integers. The integral part, the numerator
>>of the fraction and the denominator of the fraction - then interpret
>>them at the client side.
>>
>
On Wed, 18 Sep 2002, William Martell wrote:
> Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
> data representing different lengths of objects measured in inches. Can I
> load this data as is into a field in MySQL or do I have to convert it first
> into
you could store them as 3 integers. The integral part, the numerator of
the fraction and the denominator of the fraction - then interpret them
at the client side.
William Martell wrote:
> sql,query,database,odbc
>
>
> Hello All,
>
> Can anyone tell me whether I can repr
sql,query,database,odbc
Hello All,
Can anyone tell me whether I can represent fractions in MySQL 4. I have
data representing different lengths of objects measured in inches. Can I
load this data as is into a field in MySQL and still retain the same value
or do I have to convert it first to a
At 20:47 -0500 9/18/02, William Martell wrote:
>Hello.
>
>Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
>data representing different lengths of objects measured in inches. Can I
>load this data as is into a field in MySQL or do I have to convert it
Hello.
Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
data representing different lengths of objects measured in inches. Can I
load this data as is into a field in MySQL or do I have to convert it first
into an floating point interger or decimal value???
Thanks in
11 matches
Mail list logo
