X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 87D9E474E4F
	for <pgsql-sql@postgresql.org>; Thu,  3 Apr 2003 09:26:37 -0500 (EST)
Received: from jester.inquent.com
	(CPE00508b028d7d-CM00803785c5e0.cpe.net.cable.rogers.com
	[24.103.51.175])
	by postgresql.org (Postfix) with ESMTP id 552CF474E44
	for <pgsql-sql@postgresql.org>; Thu,  3 Apr 2003 09:26:32 -0500 (EST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by jester.inquent.com (8.12.6/8.12.6) with ESMTP id h33EQmwv023750;
	Thu, 3 Apr 2003 09:26:48 -0500 (EST) (envelope-from rbt@rbt.ca)
Subject: Re: simple trigger question ...
From: Rod Taylor <rbt@rbt.ca>
To: "Marc G. Fournier" <scrappy@hub.org>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20030403061142.V72033@hub.org>
References: <20030402223933.M71125@hub.org> <25296.1049341477@sss.pgh.pa.us>
	<20030403000605.U71125@hub.org> <25512.1049343373@sss.pgh.pa.us>
	<20030403002922.Y71125@hub.org> <25618.1049344429@sss.pgh.pa.us>
	<20030403061142.V72033@hub.org>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-HAMBiXyDzSMhfijSJ1bK"
Organization: 
Message-Id: <1049380007.22629.14.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.2 
Date: 03 Apr 2003 09:26:48 -0500
X-Spam-Status: No, hits=-37.8 required=5.0
	tests=BAYES_10,IN_REP_TO,PGP_SIGNATURE_2,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_XIMIAN
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/35
X-Sequence-Number: 12736

--=-HAMBiXyDzSMhfijSJ1bK
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> 'K, that makes it workable ... final question (I hope!) ... RULEs vs
> TRIGGERs?  I ended up doing it as a RULE, since I could do it without a
> function ... but is there a reason why that is a Bad Idea?  Or in a case
> like this, it doesn't really matter?

Rules are per statement, not per row.

An INSERT INTO ... SELECT ... statement will cause a single execution of
the rule even if you insert several hundred rows.

--=20
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

--=-HAMBiXyDzSMhfijSJ1bK
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQA+jESn6DETLow6vwwRAguJAJ0WfSoW8XJ3/EryXHN/4Wv1RatNFgCcC77i
DIX5Km500fcBY5xdccSvCHA=
=bEN3
-----END PGP SIGNATURE-----

--=-HAMBiXyDzSMhfijSJ1bK--