/
balmaster
/
postgres
Обзор
Документация
Войти
/
balmaster
/
postgres
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/plsample/sql/plsample.sql
38 строк
1 KB
Tom Lane
Extend plsample example to include a trigger handler.
08 апр 2022, 01:26
08 апр 2022, 01:26
2f4d0d6
Код
Авторство
О чём код?
CREATE EXTENSION plsample; -- Create and test some dummy functions CREATE FUNCTION plsample_result_text(a1 numeric, a2 text, a3 integer[]) RETURNS TEXT AS $$ Example of source with text result. $$ LANGUAGE plsample; SELECT plsample_result_text(1.23, 'abc', '{4, 5, 6}'); CREATE FUNCTION plsample_result_void(a1 text[]) RETURNS VOID AS $$ Example of source with void result. $$ LANGUAGE plsample; SELECT plsample_result_void('{foo, bar, hoge}'); CREATE FUNCTION my_trigger_func() RETURNS trigger AS $$ if TD_event == "INSERT" return TD_NEW elseif TD_event == "UPDATE" return TD_NEW else return "OK" end $$ language plsample; CREATE TABLE my_table (num integer, description text); CREATE TRIGGER my_trigger_func BEFORE INSERT OR UPDATE ON my_table FOR EACH ROW EXECUTE FUNCTION my_trigger_func(); CREATE TRIGGER my_trigger_func2 AFTER INSERT OR UPDATE ON my_table FOR EACH ROW EXECUTE FUNCTION my_trigger_func(8); INSERT INTO my_table (num, description) VALUES (1, 'first'); UPDATE my_table SET description = 'first, modified once' WHERE num = 1;