Andy Dale wrote:
Hi, I wanted to setup a simple "generic" type trigger. What a mean by generic is that i don't want to hardcode the NEW.<column> or OLD.<column> calls, i searched for a way to loop over the NEW/OLD rowtypes but could not figure out how it should be done.
Don't use plpgsql - that's the secret. Try pltcl or plperl or similar. PL/pgsql is a bit too "statically typed" for it.
-- Richard Huxton Archonet Ltd