Re: [GENERAL] 9.1 Trigger question

2011-03-10 Thread Michael Black
Thank you for the link Merlin. > Date: Thu, 10 Mar 2011 08:22:13 -0600 > Subject: Re: [GENERAL] 9.1 Trigger question > From: mmonc...@gmail.com > To: michaelblack75...@hotmail.com > CC: pgsql-general@postgresql.org > > On Wed, Mar 9, 2011 at 8:24 PM, Michael Black >

Re: [GENERAL] 9.1 Trigger question

2011-03-10 Thread Merlin Moncure
On Wed, Mar 9, 2011 at 8:24 PM, Michael Black wrote: > The following from 9.1 documentation on triggers > > "SQL allows you to define aliases for the "old" and "new" rows or tables for > use in the definition of the triggered action (e.g., CREATE TRIGGER ... ON > tablename REFERENCING OLD ROW

[GENERAL] 9.1 Trigger question

2011-03-09 Thread Michael Black
The following from 9.1 documentation on triggers "SQL allows you to define aliases for the "old" and "new" rows or tables for use in the definition of the triggered action (e.g., CREATE TRIGGER ... ON tablename REFERENCING OLD ROW AS somename NEW ROW AS othername ..