Re: [HACKERS] Transform for pl/perl

Hi 2017-10-24 14:27 GMT+02:00 Anthony Bykov : > There are some moments I should mention: > 1. {"1":1}::jsonb is transformed into HV {"1"=>"1"}, while > ["1","2"]::jsonb is transformed into AV ["1", "2"] > > 2. If there is a numeric value appear in jsonb, it will be

Re: [HACKERS] Transform for pl/perl

On Tue, Oct 24, 2017 at 1:01 PM, anthony wrote: > Hello. > Please, check out jsonb transform > (https://www.postgresql.org/docs/9.5/static/sql-createtransform.html) > for pl/perl language I've implemented. Neat. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com

Re: [HACKERS] Transform for pl/perl

There are some moments I should mention: 1. {"1":1}::jsonb is transformed into HV {"1"=>"1"}, while ["1","2"]::jsonb is transformed into AV ["1", "2"] 2. If there is a numeric value appear in jsonb, it will be transformed to SVnv through string (Numeric->String->SV->SVnv). Not the best solution,