Hi!
>>>>> "Steve" == Steve Edberg <[EMAIL PROTECTED]> writes: Steve> ...perhaps a NEAR function could be added; as a config file or compile-time Steve> option, you could define an accuracy range. Say, Steve> ./config --with-epsilon=0.0001 Steve> (if memory of my numerical analysis classes serves, the 'fudge factor' was Steve> conventionally symbolized by epsilon; I suppose you could make it Steve> --with-fudge, but this ain't no bakery) so that Steve> select 1.0 near 1.00009 => 1 Steve> and Steve> select 1.0 near 0.9995 => 0 Steve> The default would be current behavior (epsilon=0). Steve> This would avoid statements like Steve> select * where x > 0.99999999 and x < 1.00000001 Steve> ...just my too sense - Steve> -steve First a note; We can't generally have a fudge factor for floating point values. The problem with this is that if you do 3 selects: SELECT * from x where < 1 SELECT * from x where == 1 SELECT * from x where > 1 you would get some of the records in all of the above 3 sets. This could easily in the long run cause even more confusion than the current scenario. But a near function/operator would probably be a good idea; We will put this on our todo. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ 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
