collating sequences do not apply to floating point comparisons, do they
?
> -----Original Message-----
> From: Dan Kennedy [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 20, 2005 5:12 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Problem with floating point fields, and
> a feature request
>
>
> > two floats A and B should be compared with this algorithm :
> >
> > diff=A-B
> > if (diff>tolerance) then A>B
> > else if (diff<-tolerance) then A<B
> > else A = B
>
> You could define a new collation sequence to do all that.
> However, it's difficult to say what will happen when you have
> three numbers A, B and C such that A==B and B==C but A!=C.
> This will cause the occasional oddity.
>
> But if you know for some reason this will never happen,
> everything will work fine. "Know"....
>
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
>
>
>