Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group