> 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:
> When I use my own ODBC SQL client to select the same value from my
> Postgres 8.0 database, I get the same thing:
> *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:
> 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.
In response to
pgsql-odbc by date
|Next:||From: Tom Lane||Date: 2006-06-14 02:19:15|
|Subject: Re: adding psqlodbc driver in ODBCconfig |
|Previous:||From: ricardd||Date: 2006-06-13 21:32:10|
|Subject: Re: adding psqlodbc driver in ODBCconfig|