Re: Transform for pl/perl - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Transform for pl/perl
Date
Msg-id 11284.1523282666@sss.pgh.pa.us
Whole thread Raw
In response to Re: Transform for pl/perl  (ilmari@ilmari.org (Dagfinn Ilmari Mannsåker))
Responses Re: Transform for pl/perl
List pgsql-hackers
ilmari@ilmari.org (Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?=) writes:
> I tried fixing this by adding an 'if (SvUV(in))' clause to
> SV_to_JsonbValue, but I couldn't find a function to create a numeric
> value from an uint64.  If it's not possible, should we error on UVs
> greater than PG_INT64_MAX?

I think you'd have to convert to text and back.  That's kind of icky,
but it beats failing.

Or we could add a not-visible-to-SQL uint8-to-numeric function in
numeric.c.  Not sure if this is enough use-case to justify that
though.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [sqlsmith] Failed assertion on pfree() viaperform_pruning_combine_step
Next
From: Tom Lane
Date:
Subject: Re: Boolean partitions syntax