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

Reply via email to