On Fri, 01 Feb 2002 15:21:07 -0800 Steve Edberg <[EMAIL PROTECTED]> wrote:
> ...perhaps a NEAR function could be added; as a config file or > compile-time option, you could define an accuracy range. Say, > > ./config --with-epsilon=0.0001 > > (if memory of my numerical analysis classes serves, the 'fudge factor' > was conventionally symbolized by epsilon; I suppose you could make it > --with-fudge, but this ain't no bakery) so that > > select 1.0 near 1.00009 => 1 > and > select 1.0 near 0.9995 => 0 > > The default would be current behavior (epsilon=0). > > This would avoid statements like > > select * where x > 0.99999999 and x < 1.00000001 > > ...just my too sense - > > -steve > HI! This is doable of course, but current code does not use any factor. The above variant would slow down many operations, while making a few faster. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php