Re: numeric type issue

Valdas Rutkauskas wrote:
> Thanks!
>
> Do you know if this bug is only for *nix version ? We using this driver in windows and do not see isue there.

This bug doesn't exist in Windows version.

regards,
Hiroshi Inoue

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