public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: Fabien COELHO <[email protected]>
Cc: PostgreSQL Patches <[email protected]>
Subject: Re: "ALSO" keyword to "CREATE RULE" patch
Date: Wed, 3 Mar 2004 14:03:15 -0500 (EST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>


Is ALSO part of the SQL standard?  I can't imagine it is because there
is no rule mention.  

I guess if were were coding from scratch, we could make the syntax
INSTEAD or ALSO, but at this point, I don't see adding ALSO as a useful
change.

---------------------------------------------------------------------------

Fabien COELHO wrote:
> 
> Dear patchers,
> 
> Please find attached a small patch to add an optionnal "ALSO" keyword
> to the "CREATE RULE" syntax.
> 
> The "ALSO" keyword can be used where "INSTEAD" would be used,
> to mean the opposite, i.e. the current default behavior of rules
> which adds operations to the current one. IMHO, it makes the
> intended behavior much clearer for the basic user (say, me;-).
> 
> CREATE RULE some_table_del AS
>   ON DELETE TO some_table DO ALSO
>   (
>     DELETE FROM this_other_table WHERE id=old.id;
>   );
> 
> Of course, the absence of the "ALSO" keyword preserves the previous
> behavior... that is it behaves the same as with the "ALSO" keyword.
> 
> This patch was made against 7.4.1 with the "difforig" script
> provided by postgresql.
> 
> It adds "ALSO" keyword in the parser code (two lines), fixes somehow the
> documentation and sql help, and modifies four of the "RULE"
> test cases to use this keyword instead of the default nothing-ness.
> 
> It validated for me with a "make check".
> 
> Have a nice day,
> 
> -- 
> Fabien Coelho - [email protected]

Content-Description: 

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

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

view thread (15+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: "ALSO" keyword to "CREATE RULE" patch
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox