Re: Dynamically accessing columns from a row type in a trigger

[Rob Sargent]

So the less obvious solution that works is to create a temporary
table. A little verbose, but I get to keep the types.
`CREATE TEMPORARY TABLE _ ON COMMIT DROP AS SELECT OLD.*;`

_ as a table name makes things a little easier to type.



Rhys
Peace & Love | Live Long & Prosper


If the connection creating the table is long-lived, maybe make the table 
once and truncate instead.