Postgres Pro
Downloads
Home   >   mailing lists

Thread: PG 12 hstore creation cast issue

PG 12 hstore creation cast issue

From
Wells Oliver
Date:
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?

--

Re: PG 12 hstore creation cast issue

From
Tom Lane
Date:
Wells Oliver <wells.oliver@gmail.com> writes:
> 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?

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

            regards, tom lane

Re: PG 12 hstore creation cast issue

From
Wells Oliver
Date:
Yeah. Dang, hoist by own convenience petard. My own doing, folks.

Appreciate the detail.

On Wed, Oct 30, 2019 at 10:55 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Wells Oliver <wells.oliver@gmail.com> writes:
> 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?

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

                        regards, tom lane


--