Received: from mail.sbe-zeta.de (mail@[195.24.97.170]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA10116 for ; Tue, 5 Oct 1999 04:50:26 -0400 (EDT) (envelope-from F.Makesch@sbe-zeta.de) Received: from pinguin.offenbachstr.sbe-zeta.de (pinguin) [192.168.50.5] (florian) by mail.sbe-zeta.de with smtp (Exim 2.05 #1 (Debian)) id 11YQIS-0001RY-00; Tue, 5 Oct 1999 10:50:08 +0200 From: Florian Makesch Reply-To: F.Makesch@sbe-zeta.de Organization: SBE - System Bau Elemente To: pgsql-sql@postgresql.org Subject: 2 Aktions in a Rule Date: Tue, 5 Oct 1999 10:43:59 +0200 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <99100510500800.05539@pinguin> Content-Transfer-Encoding: 8bit Hello, I hope someone can help me. I Want 2 Aktions executeed in a Rule like: CREATE RULE auftraege_neu_delete AS ON delete TO auftraege_neu DO (DELETE FROM auftraege_neu_positionen WHERE auftraege_neu_positionen.auftragsnr = OLD.auftragsnr; DELETE FROM auftraege_neu_zubehoer WHERE auftraege_neu_zubehoer.auftragsnr = OLD.auftragsnr;); but I get a Parser Error: ERROR: parser: parse error at or near "" This is in PostgreSQL 6.5.2 Has anyone the correct syntax? regards Florian