Re: numeric type issue

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Valdas Rutkauskas <vrutkauskas(at)techniumconsulting(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: numeric type issue
Date: 2010-02-15 23:49:22
Message-ID: 4B79DD82.3090906@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2010-02-16 01:00:03 Re: invalid byte sequence for encoding "UTF8"
Previous Message luke 2010-02-15 16:03:59 invalid byte sequence for encoding "UTF8"