| 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; |