conditional rules VS 1 unconditional rule with multiple commands? - Mailing list pgsql-general

From Davor J.
Subject conditional rules VS 1 unconditional rule with multiple commands?
Date
Msg-id htli0h$udk$1@news.hub.org
Whole thread Raw
Responses Re: conditional rules VS 1 unconditional rule with multiple commands?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List 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



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: UPDATE...RETURNING col INTO var - what is returned?
Next
From: venu madhav
Date:
Subject: Auto vacuum configuration in postgres.