Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes16kdownloads

rootpgsqlshareextensionjsonb_plpython3u--1.0.sql

jsonb_plpython3u--1.0.sql20 linesDownload Raw Back to extension

1/* contrib/jsonb_plpython/jsonb_plpython3u--1.0.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION jsonb_plpython3u" to load this file. \quit5 6CREATE FUNCTION jsonb_to_plpython3(val internal) RETURNS internal7LANGUAGE C STRICT IMMUTABLE8AS 'MODULE_PATHNAME', 'jsonb_to_plpython';9 10CREATE FUNCTION plpython3_to_jsonb(val internal) RETURNS jsonb11LANGUAGE C STRICT IMMUTABLE12AS 'MODULE_PATHNAME', 'plpython_to_jsonb';13 14CREATE TRANSFORM FOR jsonb LANGUAGE plpython3u (15    FROM SQL WITH FUNCTION jsonb_to_plpython3(internal),16    TO SQL WITH FUNCTION plpython3_to_jsonb(internal)17);18 19COMMENT ON TRANSFORM FOR jsonb LANGUAGE plpython3u IS 'transform between jsonb and Python';20