/
balmaster
/
postgres
Обзор
Документация
Войти
/
balmaster
/
postgres
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/pl/plpython/sql/plpython_global.sql
38 строк
904 B
Andres Freund
plpython: Remove regression test infrastructure for Python 2.
08 мар 2022, 05:20
08 мар 2022, 05:20
db23464
Код
Авторство
О чём код?
-- -- check static and global data (SD and GD) -- CREATE FUNCTION global_test_one() returns text AS 'if "global_test" not in SD: SD["global_test"] = "set by global_test_one" if "global_test" not in GD: GD["global_test"] = "set by global_test_one" return "SD: " + SD["global_test"] + ", GD: " + GD["global_test"]' LANGUAGE plpython3u; CREATE FUNCTION global_test_two() returns text AS 'if "global_test" not in SD: SD["global_test"] = "set by global_test_two" if "global_test" not in GD: GD["global_test"] = "set by global_test_two" return "SD: " + SD["global_test"] + ", GD: " + GD["global_test"]' LANGUAGE plpython3u; CREATE FUNCTION static_test() returns int4 AS 'if "call" in SD: SD["call"] = SD["call"] + 1 else: SD["call"] = 1 return SD["call"] ' LANGUAGE plpython3u; SELECT static_test(); SELECT static_test(); SELECT global_test_one(); SELECT global_test_two();