WL#368: near function

Status: Assigned   —   Priority: High

...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
         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.00000