Trigger function
От | Kent L. Nasveschuk |
---|---|
Тема | Trigger function |
Дата | |
Msg-id | 1071341736.2220.175.camel@1134 обсуждение исходный текст |
Ответы |
Re: Trigger function
|
Список | pgsql-admin |
Hello, I'm trying to write a trigger that upon inserting a value in a table another table is decremented. Something that could be used in an inventory system, for example. I know it can be done easily outside POSTGRES with PHP but in this case I would like the database to handle it. Example: create table order ( order_number integer not null default nextval('order_number_seq'::text), itemid number integer references inventory, item_amt integer, cost numeric(3,2), constraint order_pk primary key(order_number) ); create table inventory ( itemid integer not null default nexval('itemid_seq'::text), onhand integer not null default 0, onorder integer not null default 0, desc varchar(30) not null, cost numeric(3,2) not null, constraint inventory_pk primary key(itemid) ); Can you give me some direction on how to do this. In this case decrement the inventory by the amount of the order for that particular item. I'm not sure how to pass variables to triggers and/or functions. Thank you -- Kent L. Nasveschuk <kent@wareham.k12.ma.us>
В списке pgsql-admin по дате отправления: