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

numeric type issue

From: Valdas Rutkauskas <vrutkauskas(at)techniumconsulting(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: numeric type issue
Date: 2010-02-12 17:51:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

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 ? .  Would it be safe to use postgresql-odbc-08.03.0400-1PGDG.rhel5 driver with 8.4.2-1 postgres?



pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2010-02-12 22:47:06
Subject: Re: How to speedup inserts via ADO ?
Previous:From: Arnaud LesauvageDate: 2010-02-12 11:10:24
Subject: How to speedup inserts via ADO ?

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