MySQL wrote:
> You might also consider using two integer type fields - one for the
> numerator and another for the denominator. This way storage and recovery are
> easy and the mathematics are wide open.
> _M
>
>I suspect that a float add is faster than 3 integer multiplies and
>sum.
>
>From: MySQL <[EMAIL PROTECTED]>
>
> From: "Madscientist" <[EMAIL PROTECTED]>
>
> You might also consider using two integer type fields - one for the
> numerator and another for the denominator. This way storage and recovery are
> easy and the mathematics are wide open.
> _M
>
>I suspect
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
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 <[EMAIL PROTECTED]>
News-Group: list.mysql
Reply-To: <[EMAIL PROTECTED]>
At 20:47 -0500 9/18/02
[ 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 an floating po
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 represent fractions in My
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 first
>into an flo
