You should use PL/pgSQL or PL/TCL language to to this.
I'm using it alot. It works. Read the dox.
On 11-Oct-99 Nicolas Boretos wrote:
> Hello,
>
> I would like to move triggers from the client side of my app to the
> backend but am confused as how to do it, particularly with the
> "function" switch on the trigger creation. The docs say a user defined
> "c" function but I only want to run some updates to my tables (sql
> statements).
> Can someone give a concrete example of this?
>
> Sincerely,
> Nicolas Boretos
>
> ************
Sergey Bondarenko
Relcom-Ukraine system administrator