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

Re: float8 auto truncation issue in ODBC v. PGSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: postgresql(dot)org(at)tgice(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: float8 auto truncation issue in ODBC v. PGSQL
Date: 2006-06-13 20:14:49
Message-ID: 10152.1150229689@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
postgresql(dot)org(at)tgice(dot)com writes:
> 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

By default, the float8 output routine prints a digit or so less than it
could, precisely to avoid that sort of unsightly result.  You can fool
with float_extra_digits (I think that's the right name, check the docs)
if you need to adjust this behavior.

This would only matter within a plpgsql function if you are doing
something that forces the binary value to be converted to text.  Which,
if you're doing tense float computation, you probably don't want to have
happen at all.

			regards, tom lane

In response to

Responses

pgsql-odbc by date

Next:From: Campbell, GregDate: 2006-06-13 21:02:30
Subject: Re: float8 auto truncation issue in ODBC v. PGSQL
Previous:From: postgresql.orgDate: 2006-06-13 19:28:34
Subject: float8 auto truncation issue in ODBC v. PGSQL

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