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
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... |