conditional rules VS 1 unconditional rule with multiple commands?

From: "Davor J(dot)" <DavorJ(at)live(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: conditional rules VS 1 unconditional rule with multiple commands?
Date: 2010-05-27 10:36:12
Message-ID: htli0h$udk$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just wonder whether the two are equivalent from user perspective: As far
as I see, you can always rewrite a multi-command rule as a conditional rule
and vice versa. Further more, Postgres seems to execute all the conditional
rules, just as if it would execute all the commands in the one unconditional
rule. So, I just wonder if there is any use in using conditionals in rules
over one multi-command rule?

Regards,
Davor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Roffler 2010-05-27 11:22:59 XML index
Previous Message paladine 2010-05-27 10:21:45 Re: reducing postgresql disk space