Re: Can't compare decimal columns???

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.