Thanks for the quick response, i think will try it with python or perl.
Cheers, Andy On 24/04/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
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