X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7DB5DD1E7E6 for ; Tue, 20 Jan 2004 16:03:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 58481-03 for ; Tue, 20 Jan 2004 12:02:36 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id C8739D1E840 for ; Tue, 20 Jan 2004 12:02:30 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0KG2TpH024301; Tue, 20 Jan 2004 11:02:29 -0500 (EST) To: Richard Huxton Cc: Neil Conway , Harald Fuchs , pgsql-performance@postgresql.org Subject: Re: Trigger question In-reply-to: <200401200813.57147.dev@archonet.com> References: <400691EA.96598C34@t1.unisoftbg.com> <871xpvij42.fsf@mailbox.samurai.com> <200401200813.57147.dev@archonet.com> Comments: In-reply-to Richard Huxton message dated "Tue, 20 Jan 2004 08:13:56 +0000" Date: Tue, 20 Jan 2004 11:02:29 -0500 Message-ID: <24300.1074614549@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/197 X-Sequence-Number: 5371 Richard Huxton writes: > On Tuesday 20 January 2004 00:01, Neil Conway wrote: >> Yeah, I didn't get around to implementing that. If anyone wants this >> feature, I'd encourage them to step up to the plate -- I'm not sure >> when I'll get the opportunity/motivation to implement this myself. > I didn't think they'd be meaningful for a statement-level trigger. Surely > OLD/NEW are by definition row-level details. According to the complainants, OLD/NEW are commonly available as recordsets (tables) inside a statement trigger. I'm not very clear on how that works myself --- in particular, one would think it important to be able to work with corresponding pairs of OLD and NEW rows, which would be painful with a table-like abstraction. Can anyone explain exactly how it's done in, say, Oracle? regards, tom lane