/
balmaster
/
postgres
Обзор
Документация
Войти
/
balmaster
/
postgres
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/jsonb_plpython/jsonb_plpython3u--1.0.sql
19 строк
732 B
Peter Eisentraut
Transforms for jsonb to PL/Python
28 мар 2018, 15:37
28 мар 2018, 15:37
3f44e3d
Код
Авторство
О чём код?
/* contrib/jsonb_plpython/jsonb_plpython3u--1.0.sql */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION jsonb_plpython3u" to load this file. \quit CREATE FUNCTION jsonb_to_plpython3(val internal) RETURNS internal LANGUAGE C STRICT IMMUTABLE AS 'MODULE_PATHNAME', 'jsonb_to_plpython'; CREATE FUNCTION plpython3_to_jsonb(val internal) RETURNS jsonb LANGUAGE C STRICT IMMUTABLE AS 'MODULE_PATHNAME', 'plpython_to_jsonb'; CREATE TRANSFORM FOR jsonb LANGUAGE plpython3u ( FROM SQL WITH FUNCTION jsonb_to_plpython3(internal), TO SQL WITH FUNCTION plpython3_to_jsonb(internal) ); COMMENT ON TRANSFORM FOR jsonb LANGUAGE plpython3u IS 'transform between jsonb and Python';