v6.5.3
While testing the new ODBC driver I ran into the following problem with
queries on numeric fields. Unless the values are surrounded by single quote
marks, the query fails with the message: Unable to identify an operator '='
for types 'numeric' and 'float'. This occurs in the WHERE clause of the
query.
SELECT * from tbl WHERE numfld = 99.125;
UPDATE tbl SET numfld = 99.13 WHERE numfld = 99.125;
An INSERT works fine.
These statements execute ok on float fields, but not numeric. This happens
via ODBC and also with psql from a Linux console.
Ken