Re: numeric type issue - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: numeric type issue
Date
Msg-id 4B79DD82.3090906@tpf.co.jp
Whole thread Raw
In response to numeric type issue  (Valdas Rutkauskas <vrutkauskas@techniumconsulting.com>)
Responses Re: numeric type issue  (Valdas Rutkauskas <vrutkauskas@techniumconsulting.com>)
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: luke
Date:
Subject: invalid byte sequence for encoding "UTF8"
Next
From: Hiroshi Inoue
Date:
Subject: Re: invalid byte sequence for encoding "UTF8"