Re: Generic triggers ?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Andy Dale <andy(dot)dale(at)gmail(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Generic triggers ?
Date: 2007-04-24 15:44:11
Message-ID: 462E25CB.9090109@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-04-24 16:15:00 Re: pgsql-general@postgresql.org
Previous Message Martijn van Oosterhout 2007-04-24 15:42:12 Re: Generic triggers ?