Re: conditional rules VS 1 unconditional rule with multiple commands?

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: "Davor J(dot)" <DavorJ(at)live(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: conditional rules VS 1 unconditional rule with multiple commands?
Date: 2010-05-28 00:30:45
Message-ID: 96C88FE3-5116-4649-9B2D-E990306015F5@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 27 May 2010, at 12:36, Davor J. wrote:

> 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?

I think if you want any meaningful answers you should start by explaining what exactly you mean by <subject>. An example would help.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.

!DSPAM:737,4bff0ec010411146380094!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2010-05-28 00:36:12 Re: List traffic
Previous Message Devrim GÜNDÜZ 2010-05-27 20:48:51 Re: Download