agora inbox for postgres@postgres.berkeley.edu  
help / color / mirror / Atom feed
rule execution
2+ messages / 2 participants
[nested] [flat]

* rule execution
@ 1995-02-12 22:58  Aarti Pai <paiaa@euler.mcs.utulsa.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Aarti Pai @ 1995-02-12 22:58 UTC (permalink / raw)
  To: legacy; +Cc: paiaa@euler.mcs.utulsa.edu


I am new to Postgres.  I am using the 4.2 version. 
I've defined several rules on a single relation.
I would like to execute a certain rule.  
How do I go about doing this?  There is no information
on the "execute" command in the reference manual.  (If that
is the appropriate command.)  I appreciate your help.

Aarti Pai 	paiaa@euler.mcs.utulsa.edu

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: rule execution
@ 1995-02-13 03:28  Paul M. Aoki <aoki@cs.berkeley.edu>
  parent: Aarti Pai <paiaa@euler.mcs.utulsa.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Paul M. Aoki @ 1995-02-13 03:28 UTC (permalink / raw)
  To: Aarti Pai <paiaa@euler.mcs.utulsa.edu>; +Cc: legacy

paiaa@euler.mcs.utulsa.edu (Aarti Pai) writes:
> I am new to Postgres.  I am using the 4.2 version.  I've defined
> several rules on a single relation.  I would like to execute a
> certain rule.  How do I go about doing this?

the only way to execute a rule is to fire it (i.e., by running a
query that matches the condition under which it is supposed to be
triggered).

if two rules are defined in such a way that you cannot formulate a
query that does not trigger one without triggered the other, then you
lose.  there is no way to turn off rules temporarily (though you can
remove them, of course).
--
  Paul M. Aoki          |  University of California at Berkeley
  aoki@CS.Berkeley.EDU  |  Dept. of EECS, Computer Science Division (#1776) 
                        |  Berkeley, CA 94720-1776

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1995-02-13 03:28 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-02-12 22:58 rule execution Aarti Pai <paiaa@euler.mcs.utulsa.edu>
1995-02-13 03:28 ` Paul M. Aoki <aoki@cs.berkeley.edu>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox