Postgres Pro
Downloads
Home   >   mailing lists

Re: binary protocol was Performance problem with timestamps in result sets - Mailing list pgsql-jdbc

From Marc Herbert
Subject Re: binary protocol was Performance problem with timestamps in result sets
Date
Msg-id khjbqwe5mg7.fsf@meije.emic.fr
Whole thread Raw
In response to Re: binary protocol was Performance problem with timestamps in result sets  ("mikael-aronsson" <mikael-aronsson@telia.com>)
List pgsql-jdbc
Tree view 
Marc Herbert <Marc.Herbert@continuent.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.

pgsql-jdbc by date:

Previous
From: Marc Herbert
Date:
Subject: Re: binary protocol was Performance problem with timestamps in result sets
Next
From: Kris Jurka
Date:
Subject: Re: java.sql.SQLException: No suitable driver