Re: numeric type and odbc from access 2000

From: "Stefan Waidele jun(dot)" <St(dot)Waidele(dot)jun(at)Krone-Neuenburg(dot)de>
To: "Richard Huxton" <dev(at)archonet(dot)com>, "Shahab Asgharzadeh" <shahab(at)nwu(dot)edu>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: numeric type and odbc from access 2000
Date: 2001-02-08 13:52:23
Message-ID: 5.0.2.1.0.20010208144736.02313bd8@imap.Krone-Neuenburg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 15:47 07.02.2001 +0000, Richard Huxton wrote:
>[...] It is treating "100.200" as float and can't find an '=' operator that
>matches numeric with float. You can handle it with
>
>where col3=100.200::numeric

Yes, we can, but Access cannot, I have not found out how Delphi can, either.
If You Quote the values, everything is all right, too.

So whose fault is it? Delphi/Access for not casting/quoting,
or is it a Postgres-Bug, not recognizing 100.200 as a valid NUMERIC(6,3) :-)

But most important how can we work around it from Delphi or Access?
Any Ideas?

Stefan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter T Mount 2001-02-08 14:03:45 Re: Auto-timestamp generator (attached)
Previous Message omid omoomi 2001-02-08 13:42:50 Re: Aggregates and joined tables...