diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2015-03-11 15:44:17 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2015-03-11 15:46:06 -0400 |
| commit | 1ce7a57ca6e8c5212fa2ab3bf31d56c74d5b5b8f (patch) | |
| tree | 5fdfa4fed33013bdc19b14844f765037c27f1939 /src/pl/plpython/sql | |
| parent | bc93ac12c2544b6b3a68b6cb0282e0828fa14a34 (diff) | |
| download | postgresql-1ce7a57ca6e8c5212fa2ab3bf31d56c74d5b5b8f.tar.gz postgresql-1ce7a57ca6e8c5212fa2ab3bf31d56c74d5b5b8f.zip | |
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>
Diffstat (limited to 'src/pl/plpython/sql')
| -rw-r--r-- | src/pl/plpython/sql/plpython_types.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/pl/plpython/sql/plpython_types.sql b/src/pl/plpython/sql/plpython_types.sql index d9d0db66bcc..19d920d3c7b 100644 --- a/src/pl/plpython/sql/plpython_types.sql +++ b/src/pl/plpython/sql/plpython_types.sql @@ -122,6 +122,7 @@ SELECT * FROM test_type_conversion_float8(100); SELECT * FROM test_type_conversion_float8(-100); SELECT * FROM test_type_conversion_float8(5000000000.5); SELECT * FROM test_type_conversion_float8(null); +SELECT * FROM test_type_conversion_float8(100100100.654321); CREATE FUNCTION test_type_conversion_oid(x oid) RETURNS oid AS $$ |