Received: from orion3.ori-ind.com (IDENT:root@[206.81.197.190])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA41603
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 1 Feb 2000 12:56:47 -0500 (EST) (envelope-from ken@ori-ind.com)
Received: from ken (stimpy.ori-ind.com [192.168.61.96])
	by orion3.ori-ind.com (8.8.7/8.8.7) with SMTP id KAA13756
	for <pgsql-interfaces@postgreSQL.org>; Tue, 1 Feb 2000 10:07:11 -0800
Message-Id: <3.0.1.32.20000201095714.00b16440@ori-ind.com>
X-Sender: ken@ori-ind.com
X-Mailer: Windows Eudora Pro Version 3.0.1 (32)
Date: Tue, 01 Feb 2000 09:57:14 -0800
To: pgsql-interfaces@postgreSQL.org
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: problem with numeric
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

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