chris.gamble@CPBINC.com writes:
> Heres the one with the float8's with an explain.
> SELECT * FROM tdatcustomerlist WHERE float8gt(longitude,-87.09486892480946)
> AND float8lt(longitude, -87.05713307519055) AND float8gt(latitude,
> 31.095787219971054) AND float8lt(latitude, 31.124730780028944)
Try writing it in a more natural fashion:
SELECT * FROM tdatcustomerlist WHERE longitude > -87.09486892480946
AND longitude < -87.05713307519055 AND latitude > 31.095787219971054
AND latitude < 31.124730780028944
The optimizer doesn't try to do anything with function calls, only with
operators.
regards, tom lane
