Trigger with Stored Procedure [Client Points]

From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Trigger with Stored Procedure [Client Points]
Date: 2006-08-30 11:56:32
Message-ID: 55c095e90608300456x4a24948fw9edc24aaa253c256@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

My best regards ...
Ezequias

I must do trigger to update a table based on a field a Stored Procedure to
update a table based

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2006-08-30 12:50:47 Error on function parameters
Previous Message Markus Schaber 2006-08-30 08:26:04 Re: UTF8 Vs Latin9 and valid encoding.