diff options
| -rw-r--r-- | contrib/hstore_plpython/expected/hstore_plpython.out | 8 | ||||
| -rw-r--r-- | contrib/hstore_plpython/sql/hstore_plpython.sql | 8 |
2 files changed, 12 insertions, 4 deletions
diff --git a/contrib/hstore_plpython/expected/hstore_plpython.out b/contrib/hstore_plpython/expected/hstore_plpython.out index 488f01d40be..e26c72d061a 100644 --- a/contrib/hstore_plpython/expected/hstore_plpython.out +++ b/contrib/hstore_plpython/expected/hstore_plpython.out @@ -6,7 +6,9 @@ LANGUAGE plpythonu TRANSFORM FOR TYPE hstore AS $$ assert isinstance(val, dict) -plpy.info(sorted(val.items())) +i = val.items() +i.sort() +plpy.info(i) return len(val) $$; SELECT test1('aa=>bb, cc=>NULL'::hstore); @@ -23,7 +25,9 @@ LANGUAGE plpython2u TRANSFORM FOR TYPE hstore AS $$ assert isinstance(val, dict) -plpy.info(sorted(val.items())) +i = val.items() +i.sort() +plpy.info(i) return len(val) $$; SELECT test1n('aa=>bb, cc=>NULL'::hstore); diff --git a/contrib/hstore_plpython/sql/hstore_plpython.sql b/contrib/hstore_plpython/sql/hstore_plpython.sql index 2d8aab1e7ab..e096df42fae 100644 --- a/contrib/hstore_plpython/sql/hstore_plpython.sql +++ b/contrib/hstore_plpython/sql/hstore_plpython.sql @@ -8,7 +8,9 @@ LANGUAGE plpythonu TRANSFORM FOR TYPE hstore AS $$ assert isinstance(val, dict) -plpy.info(sorted(val.items())) +i = val.items() +i.sort() +plpy.info(i) return len(val) $$; @@ -21,7 +23,9 @@ LANGUAGE plpython2u TRANSFORM FOR TYPE hstore AS $$ assert isinstance(val, dict) -plpy.info(sorted(val.items())) +i = val.items() +i.sort() +plpy.info(i) return len(val) $$; |