Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9MGZBP27093; Mon, 22 Oct 2001 12:35:11 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f9LGlfc28359; Sun, 21 Oct 2001 12:47:41 -0400 (EDT) To: Joel Burton cc: Aasmund Midttun Godal , pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: CREATE RULE ON UPDATE/DELETE In-reply-to: References: Comments: In-reply-to Joel Burton message dated "Sat, 20 Oct 2001 23:31:10 -0400" Date: Sun, 21 Oct 2001 12:47:41 -0400 Message-ID: <28356.1003682861@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200110/299 X-Sequence-Number: 5252 Joel Burton writes: > CREATE VIEW dbl AS SELECT id * 2 as id, name FROM raw; > CREATE RULE dbl_update AS ON UPDATE TO dbl DO INSTEAD UPDATE raw SET > id = NEW.id, name = NEW.name WHERE OLD.id = id; Surely you'd need something like CREATE RULE dbl_update AS ON UPDATE TO dbl DO INSTEAD UPDATE raw SET id = NEW.id / 2, name = NEW.name WHERE OLD.id = id * 2; (untested...) regards, tom lane