Re: float8 auto truncation issue in ODBC v. PGSQL

postgresql.org@tgice.com wrote:
> Not sure if the ODBC list is the best place for this question, but I've 
> encountered some strange behavior and was wondering if anyone had an 
> idea as to what's going on.
> 
> I've got a float8 data type in a column.  I have a value '1.0475' 
> inserted into it.  That number cannot of course be perfectly represented 
> as a float8.
> 
> When I perform a test like this in MSSQL 7, e.g., and select it using 
> any variety of tools I get this out:
> 
>   1.0475000000000001
> 
> When I use my own ODBC SQL client to select the same value from my 
> Postgres 8.0 database, I get the same thing:
> 
>   1.0475000000000001
> 
> *However*, and here's the troubling part, when I select the exact same 
> value using psql (and I have reason to believe the same thing is going 
> on inside pl/pgsql functions), the value that comes out is:
> 
>   1.0475
> 
> Now, some of you may say, "What's your problem?  That's actually the 
> correct value!"  That's true, it is.  However, I'm confused as to the 
> differences between the result I get *from* PG via my ODBC client and 
> what Postgres shows with it's internal tools.

The odbc driver automatically issues *set extra_float_digits to 2*
  command at the beginning.

regards,
Hiroshi Inoue