Re: "ALSO" keyword to "CREATE RULE" patch

Jan Wieck wrote:
> Bruce Momjian wrote:
>
> > Jan Wieck wrote:
> >> Tom Lane wrote:
> >>
> >> > Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> >> >> Most of the patch deals with the documentation, which is rather ugly
> >> >> because it keeps telling about "INSTEAD" vs "non-INSTEAD" rules, as there
> >> >> is no name for the default behavior. I think "ALSO" fixes this issue as it
> >> >> clarifies the explanations.
> >> >
> >> > Hmm ... I find that argument much more convincing than any of the others
> >> > ...
> >> >
> >> > Jan, what do you think? You invented this command's syntax IIRC.
> >>
> >> I did not. We inherited it from Postgres 4.2. If people think an ALSO
> >> keyword will clearify things, what about renaming the whole CREATE RULE
> >> into something along the line CREATE QUERY REWRITE MACRO?
> >
> > Are you saying you don't want ALSO added?
> >
>
> No, I am saying that CREATE RULE is so often misinterpreted to work like
> a trigger and when we explain that it is more like Macro expansion
> before the query is executed they understand better. CREATE RULE itself
> is just vague, with or without ALSO.

True.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073