Why isn't there a >= or <= operator defined for floating point datatypes?
As an example:
bmccoy=> select * from account where balance between 20.00 and 99.00;
ERROR: Unable to identify an operator '>=' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast
Is this standard?
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Experience is what you get when you were expecting something else.