Re: pgsql: Transforms for jsonb to PL/Perl

2018-04-04 Thread Anthony Bykov
success of the operation). I guess the right test will look a little bit different: CREATE FUNCTION testRegexpToJsonb() RETURNS jsonb LANGUAGE plperl TRANSFORM FOR TYPE jsonb AS $$ $a = qr//; return ($a); $$; So, this may be the reason why the original testRegexpToJsonb returns the scalar result. -- Anthony Bykov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: pgsql: Transforms for jsonb to PL/Perl

2018-04-04 Thread Anthony Bykov
y have regexp: it should have a possibility to convert resulting jsonb back to perl with exact same type and data. -- Anthony Bykov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company