Re: Trouble with NEW

>
> 4) If you want to pull information from another table, you either need to set
> up a FOREIGN KEY relationship that you can leverage or you need to do a
> query in the trigger function that pulls in the necessary information.
>

I do not get where the "OR" comes from.  There is nothing magical about FOREIGN KEY that causes NEW magically contain
additionalvalues.  Foreign Key or not you still have to "...do a query in the trigger function...". 

David J.