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

Wrong numeric conversion

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Wrong numeric conversion
Date: 2005-01-16 15:26:18
Message-ID: 41EA879A.9030802@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-odbc
With CVS HEAD, numeric values are not read correctly.
The SQL_NUMERIC_STRUCT is filled with
.precision=3, .scale=5 for a number like 500.00123, which MSDASQL will 
interpret as .00123 (noticed when MSDASQL had to convert it to a 
string). Obviously the precision should be 8 or more.
The attached patch corrects this.

Regards,
Andreas

Attachment: convert.c.patch
Description: text/x-patch (462 bytes)

pgsql-odbc by date

Next:From: Dave PageDate: 2005-01-17 10:13:29
Subject: Re: Wrong numeric conversion
Previous:From: George WeaverDate: 2005-01-16 14:03:00
Subject: Re: ODBC release plans?

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