/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/ltree_plpython/sql/ltree_plpython.sql
36 строк
673 B
Andres Freund
plpython: Remove regression test infrastructure for Python 2.
08 мар 2022, 05:20
08 мар 2022, 05:20
db23464
Код
Авторство
О чём код?
CREATE EXTENSION ltree_plpython3u CASCADE; CREATE FUNCTION test1(val ltree) RETURNS int LANGUAGE plpython3u TRANSFORM FOR TYPE ltree AS $$ plpy.info(repr(val)) return len(val) $$; SELECT test1('aa.bb.cc'::ltree); CREATE FUNCTION test1n(val ltree) RETURNS int LANGUAGE plpython3u TRANSFORM FOR TYPE ltree AS $$ plpy.info(repr(val)) return len(val) $$; SELECT test1n('aa.bb.cc'::ltree); CREATE FUNCTION test2() RETURNS ltree LANGUAGE plpython3u TRANSFORM FOR TYPE ltree AS $$ return ['foo', 'bar', 'baz'] $$; -- plpython to ltree is not yet implemented, so this will fail, -- because it will try to parse the Python list as an ltree input -- string. SELECT test2();