/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/jsonb_plperl/jsonb_plperl--1.0.sql
19 строк
658 B
Peter Eisentraut
Transforms for jsonb to PL/Perl
03 апр 2018, 16:47
03 апр 2018, 16:47
341e166
Код
Авторство
О чём код?
/* contrib/jsonb_plperl/jsonb_plperl--1.0.sql */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION jsonb_plperl" to load this file. \quit CREATE FUNCTION jsonb_to_plperl(val internal) RETURNS internal LANGUAGE C STRICT IMMUTABLE AS 'MODULE_PATHNAME'; CREATE FUNCTION plperl_to_jsonb(val internal) RETURNS jsonb LANGUAGE C STRICT IMMUTABLE AS 'MODULE_PATHNAME'; CREATE TRANSFORM FOR jsonb LANGUAGE plperl ( FROM SQL WITH FUNCTION jsonb_to_plperl(internal), TO SQL WITH FUNCTION plperl_to_jsonb(internal) ); COMMENT ON TRANSFORM FOR jsonb LANGUAGE plperl IS 'transform between jsonb and Perl';