X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 358E6D1B1AB for ; Mon, 12 Jul 2004 13:47:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37211-01 for ; Mon, 12 Jul 2004 16:47:13 +0000 (GMT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id B5DB7D1B1A5 for ; Mon, 12 Jul 2004 13:47:11 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 1CF9D2BDA8; Mon, 12 Jul 2004 18:47:09 +0200 (SAST) Received: from ucsns.ucs.co.za ([127.0.0.1]) by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20630-08; Mon, 12 Jul 2004 18:46:47 +0200 (SAST) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 484732BDA9; Mon, 12 Jul 2004 18:43:34 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id A16D4DA1BA; Mon, 12 Jul 2004 18:43:34 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id 7561297642; Mon, 12 Jul 2004 18:43:34 +0200 (SAST) Date: Mon, 12 Jul 2004 18:43:28 +0200 From: Stef To: Hilary Forbes Cc: pgsql-sql@postgresql.org Subject: Re: Order of execution of rules Message-Id: <20040712184328.285e40d6@svb.ucs.co.za> In-Reply-To: <5.1.0.14.0.20040712170344.04f144d8@mailserver.dmr.co.uk> References: <5.1.0.14.0.20040712170344.04f144d8@mailserver.dmr.co.uk> X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(z3\Mwj^XP@? Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx. X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Mon__12_Jul_2004_18_43_28_+0200_ozHQFX0Newahar9t" X-Virus-Scanned: by amavisd-new at ucs.co.za X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/74 X-Sequence-Number: 18326 --Signature=_Mon__12_Jul_2004_18_43_28_+0200_ozHQFX0Newahar9t Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit Hilary Forbes mentioned : => Can I guarantee that if I have more than one Rule on a table they will be executed in a given order? I know triggers are done alphabetically but is the same true of rules? http://www.postgresql.org/docs/7.4/static/sql-createrule.html#AEN37748 --Signature=_Mon__12_Jul_2004_18_43_28_+0200_ozHQFX0Newahar9t Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iQCVAwUBQPK/troLc+HYd7LFAQLo9wP+MKLiNKsA5lFWK1RLWrmVVXSzaE9fjaqo CfDp0tPb1k4LA6YpRo4zENzdxOd0uCAF8mHDltRGy7ZhASLWZcHns7RJrs4KUF9Y fO9wr2pHUp7iUctomV3I1qbAguIs/6dtbX0R+cA9BWyMKpKjdcIDKQtT3cb88SOU cGYCP8xn/xY= =CD9z -----END PGP SIGNATURE----- --Signature=_Mon__12_Jul_2004_18_43_28_+0200_ozHQFX0Newahar9t--