List:General Discussion« Previous MessageNext Message »
From:Michael T. Babcock Date:September 19 2002 2:56pm
Subject:Re: Fractions
View as plain text  
[ 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.

FractionsWilliam Martell19 Sep
  • Re: FractionsPaul DuBois19 Sep
    • Re: FractionsMySQL20 Sep
      • RE: FractionsMadscientist20 Sep
        • Re: FractionsMySQL21 Sep
        • Re: FractionsMichael T. Babcock23 Sep
  • Re: FractionsThomas Spahni19 Sep
Re: FractionsMichael T. Babcock19 Sep
Re: FractionsJan Steinman22 Sep