Received: from cezar.ce3.com.pl (cezar.ce3.com.pl [212.244.251.34])
	by hub.org (8.9.3/8.9.3) with ESMTP id HAA46234
	for <pgsql-interfaces@postgresql.org>;
	Wed, 19 Apr 2000 07:39:39 -0400 (EDT) (envelope-from M.Hankus@ce3.pl)
Received: from ce3.pl (komp21.ce3 [192.168.255.21])
	by cezar.ce3.com.pl (8.10.0/8.10.0) with ESMTP id e3JBd7c10695
	for <pgsql-interfaces@postgresql.org>; Wed, 19 Apr 2000 13:39:07 +0200
Message-ID: <38FD9ADA.6030107@ce3.pl>
Date: Wed, 19 Apr 2000 13:39:06 +0200
From: Mirek Hankus <M.Hankus@ce3.pl>
User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; m15)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: ODBC with fields defined as numeric(14,2)
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200004/146


  Hello. I have problem with accesing fields defined as NUMERIC(14,2) 
from Wndows applications.
I use ODBC v. 6.5 and Postgresql 7.0b5 (I'm also using Borland Builder 
5.0).
When reffering fields defined as numeric Builder generate code like

SELECT COUNT(*)  FROM "mir" WHERE "liczba"=34.50

(I've checked postgresql log file).
Postgresql complains about missing operator = (numeric, float8).

Any ideas how to fix this ????

Mirek Hankus