Skip site navigation (1) Skip section navigation (2)

Re: numeric type issue

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 (view raw or flat)
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


In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2010-02-17 03:43:35
Subject: Re: numeric type issue
Previous:From: Arnaud LesauvageDate: 2010-02-16 15:28:57
Subject: Re: How to speedup inserts via ADO ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group