summaryrefslogtreecommitdiff
path: root/contrib/ltree_plpython/ltree_plpython3u--1.0.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/ltree_plpython/ltree_plpython3u--1.0.sql')
-rw-r--r--contrib/ltree_plpython/ltree_plpython3u--1.0.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/contrib/ltree_plpython/ltree_plpython3u--1.0.sql b/contrib/ltree_plpython/ltree_plpython3u--1.0.sql
new file mode 100644
index 0000000000..1300a78c66
--- /dev/null
+++ b/contrib/ltree_plpython/ltree_plpython3u--1.0.sql
@@ -0,0 +1,12 @@
+-- make sure the prerequisite libraries are loaded
+DO '1' LANGUAGE plpython3u;
+SELECT NULL::ltree;
+
+
+CREATE FUNCTION ltree_to_plpython3(val internal) RETURNS internal
+LANGUAGE C STRICT IMMUTABLE
+AS 'MODULE_PATHNAME', 'ltree_to_plpython';
+
+CREATE TRANSFORM FOR ltree LANGUAGE plpython3u (
+ FROM SQL WITH FUNCTION ltree_to_plpython3(internal)
+);