On 29 August 2010 15:35, Tom Lane <[email protected]> wrote:
> Thom Brown <[email protected]> writes:
>> 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
>
> My recollection is that we did it that way deliberately. The originally
> submitted patch tried to explain this as part of the syntax diagram,
> but it was (a) confusing and (b) not correct in detail.
I missed the discussion is seems.
>> So it would read something like:
>
>> CREATE TRIGGER name { BEFORE | AFTER } { event [ OF column_name [, ...
>> ] ] [ OR ... ] }
>
> If you do this then it looks like "OF column_name" can be attached to
> all four event types, which is wrong. So you end up needing just as
> much verbal annotation as in the current arrangement.
Ah, yes, I didn't consider that. Fair enough.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
