Re: Generic triggers ? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Generic triggers ?
Date
Msg-id 462E25CB.9090109@archonet.com
Whole thread Raw
In response to Generic triggers ?  ("Andy Dale" <andy.dale@gmail.com>)
Responses Re: Generic triggers ?
List pgsql-general
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Generic triggers ?
Next
From: "Albe Laurenz"
Date:
Subject: Re: pgsql-general@postgresql.org