aboutsummaryrefslogtreecommitdiff
path: root/src/test/modules/test_ddl_deparse/sql/create_trigger.sql
blob: fc0aef75935fec9d5cfa73c83333a5f2bfb3ea5d (plain)
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();