Comparing two floating point numbers for equality seldom works
the way you want it to.
Without seeing the exact data you have it's hard to say for sure (as
there
may be some other issue with what you're doing) but I wouldn't expect
this to work with data from arbitrary sources.
Try
SELECT * FROM mytable WHERE myreal >= 10.49 AND myreal <= 10.51;
and see what result that gives.
This way, it works...
Philippe Ferreira.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
