Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3QKL8334659
	for <pgsql-sql@postgresql.org>; Thu, 26 Apr 2001 16:21:15 -0400 (EDT)
	(envelope-from martin@bugs.unl.edu.ar)
Received: by bugs.unl.edu.ar (Postfix, from userid 1004)
	id 525F42AB23; Thu, 26 Apr 2001 17:21:49 +0300 (GMT)
Content-Type: text/plain;
  charset="iso-8859-1"
From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.ar>
To: pgsql-sql@postgresql.org
Subject: rules
Date: Thu, 26 Apr 2001 17:21:48 +0300
X-Mailer: KMail [version 1.2]
MIME-Version: 1.0
Message-Id: <01042617214801.04659@bugs>
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200104/416
X-Sequence-Number: 2778

Is it posible to make a rule execute more then one query?

Something like:

CREATE RULE rule_name AS ON INSERT TO table1
DO INSTEAD
INSERT INTO table2 VALUES
(new.value1,new.value2)
INSERT INTO table3 VALUES
(x,y)

If not, is there a way to do this? Triggers maybe?

Saludos... :-)

-- 
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------