Re: [GENERAL] Rule, update and aggregate functions

2007-02-03 Thread Peter
Hi, I got stuck with the following problem and strangely couldn't find anything similar in the list: Assume two tables: table: warehouse, columns: id, incoming, outgoing table: articles, columns: id, articles_in_stock All I want is to create a rule, that everytime when articles leave or get in

Re: [GENERAL] Rule, update and aggregate functions

2007-02-02 Thread Mark Walker
I think you need delete, update, and insert rules for warehouse. Subtract out the old on delete & update. Add the new in update and insert. Aggregates would be an incredible waste of processor time. pgsql-user wrote: Hi, I got stuck with the following problem and strangely couldn't find a