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

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: "ALSO" keyword to "CREATE RULE" patch
Date: 2004-03-05 00:08:19
Message-ID: 4047C4F3.4000608@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

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.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2004-03-05 00:19:52 Re: "ALSO" keyword to "CREATE RULE" patch
Previous Message Bruce Momjian 2004-03-04 23:31:54 Re: "ALSO" keyword to "CREATE RULE" patch

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-03-05 00:19:52 Re: "ALSO" keyword to "CREATE RULE" patch
Previous Message Bruce Momjian 2004-03-05 00:05:05 Re: Fix for log_executor_stats