PG 12 hstore creation cast issue

Wells Oliver <[email protected]> Wed, 30 Oct 2019 09:35:38 -0700
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAOC+FBW30umnGfRkc8BD-tr-KrPZFPAd-zr19AdSrRTKCv67Pw@mail.gmail.com>
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
[email protected] <[email protected]>