Re: binary protocol was Performance problem with timestamps in result sets

From: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: binary protocol was Performance problem with timestamps in result sets
Date: 2006-03-10 15:49:44
Message-ID: khjbqwe5mg7.fsf@meije.emic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com> writes:

> To represent binary IEEE754's floats (4 bytes) without loss the
> maximum required number of base10 digits is 9. For IEEE754's doubles
> (8 bytes) it's 17. I don't know what is the "average" required number
> of digits.

Sorry, forgot to precise: that's just for the fraction. You need to
add representations for sign and exponent.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-03-10 19:25:28 Re: java.sql.SQLException: No suitable driver
Previous Message Marc Herbert 2006-03-10 15:42:49 Re: binary protocol was Performance problem with timestamps in result sets