We have this kind of code that worked in 9.6:
select hstore(array['foo'], array[1.0::numeric]);
But now yields:
ERROR: function hstore(text[], numeric[]) does not exist
LINE 1: select hstore(array['foo'], array[1.0::numeric]);
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
LINE 1: select hstore(array['foo'], array[1.0::numeric]);
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Is there a way to create hstores with numeric types as data? Does everything need to be cast as text?
