In this post, you’ll learn about the DB2 error 0-ERROR: Unable to identify an operator ‘>=’ for types ‘numeric’ and ‘double precision’ You will have to retype this query using an explicit cast and the reason why you are receiving the error message and how to fix it
How does this Error Message Looks like
0 – ERROR: Unable to identify an operator ‘>=’ for types ‘numeric’ and ‘double precision’ You will have to retype this query using an explicit cast
Reason for the Error & Solution
An integer field is mapped to a decimal column type. PostgreSQL disallows performing numeric comparisons between integers and decimals.