Received: from borg.3logic.net (borg.3logic.net [195.38.16.4]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAG9uqm19710 for ; Fri, 16 Nov 2001 04:56:52 -0500 (EST) (envelope-from andriy.pyrozhenko@vanjaonline.com) Received: (qmail 26759 invoked from network); 16 Nov 2001 11:56:44 +0200 Received: (qmail: 1.03); 16 Nov 2001 09:56:44 -0000 Received: from onetim.3logic.net (HELO mail.vanjaonline.com) (195.38.17.73) by borg.3logic.net with SMTP; 16 Nov 2001 11:56:40 +0200 Received: from PYROZHENKO ([192.168.1.10]) by mail.vanjaonline.com (WinRoute Pro 4.1.29) with SMTP; Fri, 16 Nov 2001 11:55:26 +0200 Date: Fri, 16 Nov 2001 11:38:30 +0200 From: Andriy Pyrozhenko X-Mailer: The Bat! (v1.53bis) Reply-To: Andriy Pyrozhenko X-Priority: 3 (Normal) Message-ID: <945621152.20011116113830@vanjaonline.com> To: pgsql-sql@postgresql.org Subject: Question MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/236 X-Sequence-Number: 5618 Hello pgsql-sql, I have the rule for table CREATE RULE del_jobs_del_activity AS ON DELETE TO jobs DO DELETE FROM activities WHERE job_id = OLD.job_id; When i call: DELETE FROM jobs WHERE job_id IN (SELECT DISTINCT job_id FROM activities WHERE load_no = OLD.load_no) This query does not delete the record from jobs but delete the record by rule. Best regards, Andriy mailto:andriy.pyrozhenko@vanjaonline.com