Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBG0dim56801 for ; Sat, 15 Dec 2001 19:39:44 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fBG0M7440413 for pgsql-sql@postgresql.org; Sat, 15 Dec 2001 19:22:07 -0500 (EST) (envelope-from news) X-Newsgroups: comp.databases.postgresql.sql From: marc@oscar.eng.cv.net (Marc Spitzer) Subject: should this be a trigger or a rule? Message-ID: User-Agent: slrn/0.9.7.0 (FreeBSD) Lines: 38 Date: Sun, 16 Dec 2001 00:16:52 GMT Organization: Optimum Online To: pgsql-sql@postgresql.org X-Archive-Number: 200112/158 X-Sequence-Number: 5981 I have 3 tables: pings, curr_state, ping_log and here is what I want to happen: when I insert a row into pings it checks to see if the ping was sucessful or not. Then it checks the current state of the interface in curr_state table and if they match insert the row. If they do not match then update curr_state and insert a row into ping_log. I am not askng anybody to write it for me, I just want to know what is the prefered PG method to do this. Here is my table defs: drop table pings; create table pings ( cm_mac macaddr, ts timestamp, ping1 int4, ping2 int4 primary key (cm_mac, ts) ); drop table curr_state ; create table curr_state ( cm_mac macaddr primary key, last_change, up boolean ); drop table ping_log ; create table ping_log ( cm_mac macaddr, ts timestamp, state boolean, primary key (cm_mac, ts) ); Thanks marc