Thread: pgsql: PL/Python: Avoid lossiness in float conversion
PL/Python: Avoid lossiness in float conversion PL/Python uses str() to convert Python values back to PostgreSQL, but str() is lossy for float values, so use repr() instead in that case. Author: Marko Kreen <markokr@gmail.com> Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/1ce7a57ca6e8c5212fa2ab3bf31d56c74d5b5b8f Modified Files -------------- src/pl/plpython/expected/plpython_types.out | 8 ++++++++ src/pl/plpython/plpy_typeio.c | 12 ++++++++++++ src/pl/plpython/sql/plpython_types.sql | 1 + 3 files changed, 21 insertions(+)
Peter Eisentraut wrote: > PL/Python: Avoid lossiness in float conversion > > PL/Python uses str() to convert Python values back to PostgreSQL, but > str() is lossy for float values, so use repr() instead in that case. > > Author: Marko Kreen <markokr@gmail.com> Racoon is unhappy about plpython_types_3.out -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services