Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E6964632DA0 for ; Sun, 29 Aug 2010 10:30:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 96056-09 for ; Sun, 29 Aug 2010 13:30:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.linux-foundation.org (smtp1.linux-foundation.org [140.211.169.13]) by mail.postgresql.org (Postfix) with ESMTP id 347F563295B for ; Sun, 29 Aug 2010 10:30:03 -0300 (ADT) Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) (authenticated bits=0) by smtp1.linux-foundation.org (8.14.2/8.13.5/Debian-3ubuntu1.1) with ESMTP id o7TDU0KU028442 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=FAIL) for ; Sun, 29 Aug 2010 06:30:01 -0700 Received: by vws3 with SMTP id 3so4290469vws.19 for ; Sun, 29 Aug 2010 06:29:54 -0700 (PDT) Received: by 10.220.124.74 with SMTP id t10mr1968036vcr.179.1283088593254; Sun, 29 Aug 2010 06:29:53 -0700 (PDT) MIME-Version: 1.0 Received: by 10.220.163.203 with HTTP; Sun, 29 Aug 2010 06:29:23 -0700 (PDT) From: Thom Brown Date: Sun, 29 Aug 2010 14:29:23 +0100 Message-ID: Subject: Column-level triggers in docs To: pgsql-docs Content-Type: text/plain; charset=ISO-8859-1 X-MIMEDefang-Filter: lf$Revision: 1.188 $ X-Scanned-By: MIMEDefang 2.63 on 140.211.169.13 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201008/114 X-Sequence-Number: 5938 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