Debian Codegraph @

src/test/modules/plsample/sql/plsample.sql

raw
1 CREATE EXTENSION plsample;
2 -- Create and test some dummy functions
3 CREATE FUNCTION plsample_result_text(a1 numeric, a2 text, a3 integer[])
4 RETURNS TEXT
5 AS $$
6 Example of source with text result.
7 $$ LANGUAGE plsample;
8 SELECT plsample_result_text(1.23, 'abc', '{4, 5, 6}');
9
10 CREATE FUNCTION plsample_result_void(a1 text[])
11 RETURNS VOID
12 AS $$
13 Example of source with void result.
14 $$ LANGUAGE plsample;
15 SELECT plsample_result_void('{foo, bar, hoge}');
16
17 CREATE FUNCTION my_trigger_func() RETURNS trigger AS $$
18 if TD_event == "INSERT"
19 return TD_NEW
20 elseif TD_event == "UPDATE"
21 return TD_NEW
22 else
23 return "OK"
24 end
25 $$ language plsample;
26
27 CREATE TABLE my_table (num integer, description text);
28 CREATE TRIGGER my_trigger_func BEFORE INSERT OR UPDATE ON my_table
29 FOR EACH ROW EXECUTE FUNCTION my_trigger_func();
30 CREATE TRIGGER my_trigger_func2 AFTER INSERT OR UPDATE ON my_table
31 FOR EACH ROW EXECUTE FUNCTION my_trigger_func(8);
32
33 INSERT INTO my_table (num, description)
34 VALUES (1, 'first');
35
36 UPDATE my_table
37 SET description = 'first, modified once'
38 WHERE num = 1;