> 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?
For me, that query fails that way in 9.6 too. This is unsurprising because the only two-argument variants of hstore() are
hstore(text, text) hstore(text[], text[])
both in 9.6 and current. I suppose that this case was getting covered by one of those implicit casts you got rid of, allowing numeric[] to be silently cast to text[].