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]>