create summaries and update a second table?

From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: create summaries and update a second table?
Date: 2006-01-04 18:49:30
Message-ID: 20060104184930.GH2860@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello *,

I have many tables (one per product) and the are two columns where I
put my buyed and selled pieces. Second I have a Main-Table with all
products and a summary of the stock.

What I want is, whenever I buy or sell something, the changements
(buy/sell) in the product table must triger an update in the Main-
Table.

I am puzzeling arround, how can this be done.

Any help welcome

Thanks
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Osowiecki 2006-01-04 18:50:59 Re: Unique transaction ID
Previous Message Michael Fuhr 2006-01-04 18:46:45 Re: copy from error