Re: Precision loss when INSERTing float values

Federico Di Gregorio <fog-NGVKUo/i/[email protected]>
Newsgroups gmane.comp.python.db.psycopg.devel
Organization initd.org
Message-ID <1257754671.3648.0.camel@mila>
Il giorno lun, 09/11/2009 alle 00.50 +0100, Remy Blank ha scritto:
> I have noticed a loss of precision when inserting float values into a
> table column of type DOUBLE PRECISION. The usual precision of such a
> column is 15 decimal digits. Inserting values through pgsql actually
> keeps the 15 digits, but values inserted through psycopg are truncated
> after 12 decimal digits. 
[snip]

Patch applied to git branch python2. Thank you very much.

federico

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                [email protected]
INIT.D Developer                                           fog-NGVKUo/i/[email protected]
              La felicità è una tazza di cioccolata calda. Sempre. -- Io

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg
signature.asc (application/pgp-signature, 198 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAkr30C8ACgkQvcCgrgZGjesUqACgs+MMMypI7kK1zz5uxid77ob5
7LQAnRrxV/geSNkr2btDlru/jvpQFmay
=QHUk
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.