Re: Trigger with Stored Procedure [Client Points]

["Aaron Bono" <postgresql(at)aranya(dot)com>]

On 8/30/06, Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com> wrote:

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.

 

I am not exactly sure what you are trying to do here.  Can you provide an example of the data and what you want to occur?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   
http://codeelixir.com
==================================================================