From: Tom Lane <tgl@sss.pgh.pa.us>
To: André Næss <andre.nass@student.uib.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: Conditional rule?
Date: Thu, 27 Jul 2000 11:36:10 -0400
Message-ID: <8320.964712170@sss.pgh.pa.us> (raw)
In-Reply-To: <003601bff7d9$18cdd610$74b5f8c2@wkst6>
References: <87k8e78yg9.fsf@matt.w80.math-hat.com>
<003601bff7d9$18cdd610$74b5f8c2@wkst6>
"=?iso-8859-1?B?QW5kcukgTuZzcw==?=" <andre.nass@student.uib.no> writes:
> I wish to make rule looking something like this:
> create rule newsrule as
> on insert to news do
> if new.publishtime is not null insert into news_unpublished
> values(new.id);
> I.e. "On an insert to news, if new.publish is not null, insert the new
> post's id into news_unpublished.
What you want here is a trigger, not a rule. The closest you could come
with a rule is to copy *all* unpublished ids into news_unpublished each
time something got inserted into news. There are applications for that
sort of thing, but this ain't it. See the trigger examples in the
plpgsql or pltcl sections of the manual.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, andre.nass@student.uib.no
Subject: Re: Conditional rule?
In-Reply-To: <8320.964712170@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox