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.
Is there a way to create hstores with numeric types as data? Does
everything need to be cast as text?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>