On Sun, 14 Jan 2001, Brett W. McCoy wrote:
> 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
I believe there was discussion about these things on -hackers a while
back. The type promotion and which type a constant is seen as is kind of
wierd right now. The query will probably work with explicit typecast to
numeric for the constants.