Re: [SQL] Error on dynamic code.

2005-07-15 Thread John DeSoi
On Jul 14, 2005, at 3:46 AM, Mark J Camilleri wrote: The funny thing is that the documentation I read about SELECT INTO and RECORD types give the following example, amongst others: See the section below that on EXECUTE: The results from SELECT commands are discarded by EXECUTE, and SEL

[SQL] Error on dynamic code.

2005-07-14 Thread Mark J Camilleri
I am trying to write a dynamic trigger function on insert operations so that the same function can be used across all my tables.  In this case my tables are ‘test’ and ‘test_a’ (my convention is that all audit table names are the name of the original table concatenated with ‘_a’).  Below is