[GENERAL] help me on a trigger

2006-06-02 Thread Pedro 
I need to create a trigger that decreases on a stocks table the amount that have been inserted on the tooken_from_stock table.the trigger should be something like:CREATE TRIGGER triggerdecrease
BEFORE INSERT ON tooken_from_stockEXECUTE PROCEDURE decrease();then i need to create the procedure decrease that gets the inserted tooken_from_stock.amount and subtracts it on stocks.amount
can anybody help me with this please?thanks in advance.

Re: [GENERAL] help me on a trigger

2006-06-02 Thread Terry Lee Tucker 
On Friday 02 June 2006 02:09 am, Pedro [EMAIL PROTECTED] thus communicated:
-- I need to create a trigger that decreases on a stocks table the amount
-- that have been inserted on the tooken_from_stock table.
--
-- the trigger should be something like:
--
-- CREATE TRIGGER triggerdecrease
-- BEFORE INSERT ON tooken_from_stock
-- EXECUTE PROCEDURE decrease();
--
--
-- then i need to create the procedure decrease that gets the inserted
-- tooken_from_stock.amount and subtracts it on stocks.amount
--
-- can anybody help me with this please?
--
-- thanks in advance.
--
See the documentation at the link below for a discussion on writting triggers.
http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly