From 341e1661805879db958dde0a9ed1dc44b1bb10c3 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 3 Apr 2018 09:47:18 -0400 Subject: Transforms for jsonb to PL/Perl Add a new contrib module jsonb_plperl that provides a transform between jsonb and PL/Perl. jsonb values are converted to appropriate Perl types such as arrays and hashes, and vice versa. Author: Anthony Bykov Reviewed-by: Pavel Stehule Reviewed-by: Aleksander Alekseev Reviewed-by: Nikita Glukhov --- doc/src/sgml/json.sgml | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index 1df949e304a..e7b68fa0d24 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -575,8 +575,17 @@ SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"tags": ["qu Additional extensions are available that implement transforms for the - jsonb type for the language PL/Python. The extensions for - PL/Python are called jsonb_plpythonu, + jsonb type for different procedural languages. + + + + The extensions for PL/Perl are called jsonb_plperl and + jsonb_plperlu. If you use them, jsonb + values are mapped to Perl arrays, hashes, and scalars, as appropriate. + + + + The extensions for PL/Python are called jsonb_plpythonu, jsonb_plpython2u, and jsonb_plpython3u (see for the PL/Python naming convention). If you -- cgit v1.2.3