Provided by: manpages-zh_1.5.2-1_all bug

NAME

       CREATE TRIGGER -

SYNOPSIS

       CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] }
           ON table [ FOR [ EACH ] { ROW | STATEMENT } ]
           EXECUTE PROCEDURE funcname ( arguments )

DESCRIPTION

       CREATE TRIGGER   func

         INSERTUPDATE   DELETE   INSERT UPDATE  DELETE   INSERT  UPDATE   ""

          FOR  EACH ROW  10  DELETE  ON DELETE  10   FOR EACH STATEMENT    FOR
       EACH STATEMENT

       SELECT  SELECT

         Part V ``Triggers''

PARAMETERS

       name

       BEFORE

       AFTER

       event  INSERTDELETE  UPDATE   OR

       table

       FOR EACH ROW

       FOR EACH STATEMENT
                 SQL  FOR EACH STATEMENT

       func    trigger

       arguments

NOTES

         TRIGGER

         PostgreSQL  7.3   opaque  trigger  CREATE  TRIGGER   opaque    NOTICE
       trigger

         DROP TRIGGER [drop_trigger(7)]

EXAMPLES

       Section 33.4 ``Triggers''

COMPATIBILITY

       CREATE TRIGGER  CREATE TRIGGER  SQL99  SQL92

       o SQL99 AFTER UPDATE OF col1, col2

       o SQL99   "old"  "new"  CREATE TRIGGER ... ON tablename REFERENCING OLD
         ROW AS somename NEW ROW AS othername ...) PostgreSQL

       o PostgreSQL SQL99  SQL   CREATE TABLE

       SQL99  PostgreSQL

         OR  PostgreSQL

SEE ALSO

       CREATE FUNCTION [create_function(7)], ALTER TRIGGER [alter_trigger(l)],
       DROP TRIGGER [drop_trigger(l)]

       Postgresql  <laser@pgsqldb.org>