From: | Valdas Rutkauskas <vrutkauskas(at)techniumconsulting(dot)com> |
---|---|
To: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: numeric type issue |
Date: | 2010-02-16 17:03:01 |
Message-ID: | 8C3F6C3393513F4BAFA2D95D662927231D0CCB75D0@EXVMBX020-2.exch020.serverdata.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Thanks!
Do you know if this bug is only for *nix version ? We using this driver in windows and do not see isue there.
-----Original Message-----
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
Sent: Monday, February 15, 2010 6:49 PM
To: Valdas Rutkauskas
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] numeric type issue
Valdas Rutkauskas wrote:
> 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 ?
This bug was fixed in 8.4.0200.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2010-02-17 03:43:35 | Re: numeric type issue |
Previous Message | Arnaud Lesauvage | 2010-02-16 15:28:57 | Re: How to speedup inserts via ADO ? |