Thread: Triggers on backend

Triggers on backend

From
Nicolas Boretos
Date:
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


RE: [SQL] Triggers on backend

From
Sergey Bondarenko
Date:
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