On 4/10/18 07:33, Dagfinn Ilmari Mannsåker wrote:
> 1) both the jsonb_plperl and jsonb_plperlu extensions contain the SQL
> functions jsonb_to_plperl and plperl_to_jsonb, so can't be installed
> simultaneously
>
> 2) jsonb scalar values are passed to the plperl function wrapped in not
> one, but _two_ layers of references
>
> 3) jsonb numeric values are passed as perl's NV (floating point) type,
> losing precision if they're integers that would fit in an IV or UV.
>
> 4) SV_to_JsonbValue() throws an error for infinite NVs, but not NaNs
>
> Attached is a patch for the first issue. I'll look at fixing the rest
> later this week.
Committed #1. Please keep more patches coming. :)
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services