Re: Trigger with Stored Procedure [Client Points] - Mailing list pgsql-sql

Hi list,

I have a table like this:

Points
---------------------------------
Id
operation
value

and another two tables like this

Client                                        Rule
------------------------                       -----------------------
id                                             id
name                                       percent
Points


ps: The Points table is a table that represent each moviment of the Client.


I need to make a trigger that see after all insert on Points table and update the client table based on the percent on the Rule table.

Anyone that would like to help me I will be very welcomed.