On 6 Nov 2015, at 2:20pm, Wade, William <bill.wade at dnvgl.com> wrote:
> I have an engineering application, where double can be part of a key. So do I, using Longitude and Latitude in GPS coordinates. A lot of things done inside GPS devices amount to "List everything in this rectangle". This is the problem. Theoretically we are saying "You cannot test for equality in REAL so we should remove COLLATE for REAL numbers.". But there are thousands of apps out there which use REALs in keys, get useful results fast, and don't care how edge cases are handled. So we carry on as before, occasionally telling someone new why the carpet's a bit lumpy over by the coat rack. Simon.