Hi,
Just doing some testing at the moment and trying to make a trigger that consists of a insert statement which as a result of an sql querty!
Look into using EXECUTE - it accepts a string expression and executes it. Don't forget to use the quote_xxx() functions to quote identifiers etc.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])