[ this mysql spam filter sucks -- including a query in one's message
isn't good enough ]
mysql@*stripped* 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.
>>
>>
>
>This would even have the benefit of making the whole thing sortable
>(with approximations) ...
>
># val_i := integer; val_n := numerator; val_d := denominator
>SELECT id FROM table WHERE val_i + (val_n / val_d) < 10;
>
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock