pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thom Brown <thom@linux.com>
To: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Column-level triggers in docs
Date: Sun, 29 Aug 2010 14:29:23 +0100
Message-ID: <AANLkTikh0ta8CbcGVMALqorDS75CrSjVwjtcg4AwndEN@mail.gmail.com> (raw)

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



view thread (3+ messages)  latest in thread

Message-ID: <AANLkTikh0ta8CbcGVMALqorDS75CrSjVwjtcg4AwndEN@mail.gmail.com>
Permalink:  ../AANLkTikh0ta8CbcGVMALqorDS75CrSjVwjtcg4AwndEN@mail.gmail.com/
Also on:    postgresql.org/message-id/AANLkTikh0ta8CbcGVMALqorDS75CrSjVwjtcg4AwndEN@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: thom@linux.com
  Subject: Re: Column-level triggers in docs
  In-Reply-To: <AANLkTikh0ta8CbcGVMALqorDS75CrSjVwjtcg4AwndEN@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox