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

Re: Wrong numeric conversion

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Wrong numeric conversion
Date: 2005-01-17 10:13:29
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4528442@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
 

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Andreas Pflug
> Sent: 16 January 2005 15:26
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Wrong numeric conversion
> 
> 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.

Thanks Andreas, patch applied.

Regards, Dave.

pgsql-odbc by date

Next:From: James M Doherty PGADMINDate: 2005-01-17 14:13:30
Subject: Re: ODBC release plans?
Previous:From: Andreas PflugDate: 2005-01-16 15:26:18
Subject: Wrong numeric conversion

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