Skip site navigation (1) Skip section navigation (2)

Column-level triggers in docs

From: Thom Brown <thom(at)linux(dot)com>
To: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Column-level triggers in docs
Date: 2010-08-29 13:29:23
Message-ID: AANLkTikh0ta8CbcGVMALqorDS75CrSjVwjtcg4AwndEN@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docs
I notice that the 9.0 docs page for CREATE TRIGGER doesn't indicate
column-level syntax in the synopsis:
http://www.postgresql.org/docs/9.0/static/sql-createtrigger.html

It does detail the additional syntax required for specifying a column
in the "event" parameter detail, but shouldn't this also be in the
synopsis?

So it would read something like:

CREATE TRIGGER name { BEFORE | AFTER } { event [ OF column_name [, ...
] ] [ OR ... ] }
    ON table [ FOR [ EACH ] { ROW | STATEMENT } ]
    [ WHEN ( condition ) ]
    EXECUTE PROCEDURE function_name ( arguments )

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2010-08-29 14:35:53
Subject: Re: Column-level triggers in docs
Previous:From: Thom BrownDate: 2010-08-29 10:56:55
Subject: Re: [pgsql-www] Example indenting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group