| From: | Valdas Rutkauskas <vrutkauskas(at)techniumconsulting(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | numeric type issue |
| Date: | 2010-02-12 17:51:13 |
| Message-ID: | 8C3F6C3393513F4BAFA2D95D662927231D0CCB6FC1@EXVMBX020-2.exch020.serverdata.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi,
I'm trying to migrate postgres 7.4 to postgres 8.4.2-1. Everything seems to work fine, but fields in database with NUMERIC type returning wrong values, but in the tables they are correct.
For example: I have column defined like this:
charge numeric(7,2) DEFAULT 0 NOT NULL,NOT NULL with value 6.67.
If I use psqlODBC version 08.04.0100 return value would be 6.00, but if I use driver postgresql-odbc-08.03.0400-1PGDG.rhel5 return value is 6.67 which is how it suppose to be.
Does anybody know any issues with version 08.04.0100 regarding numeric type ? . Would it be safe to use postgresql-odbc-08.03.0400-1PGDG.rhel5 driver with 8.4.2-1 postgres?
Thanks
-Valdas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2010-02-12 22:47:06 | Re: How to speedup inserts via ADO ? |
| Previous Message | Arnaud Lesauvage | 2010-02-12 11:10:24 | How to speedup inserts via ADO ? |