src/test/modules/test_ddl_deparse/sql/create_trigger.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

---
--- CREATE_TRIGGER
---

CREATE FUNCTION plpgsql_function_trigger_1()
  RETURNS TRIGGER
  LANGUAGE plpgsql
AS $$
BEGIN
  RETURN NEW;
END;
$$;

CREATE TRIGGER trigger_1
  BEFORE INSERT OR UPDATE
  ON datatype_table
  FOR EACH ROW
  EXECUTE PROCEDURE plpgsql_function_trigger_1();