Rules and SELECT

Started by Bruce Momjianover 25 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Can someone comment on this? I believe we were waiting for a comment
from Jan.

I suggest that the CREATE RULE syntax be relaxed so that
it is legal to have a list of SELECT commands in a rule.

I'll argue that:
1) The change is simple (2 lines in gram.y). Diff is
attached.
2) It breaks nothing (more things become legal)
3) It makes the parser agree with the published syntax,
which currently makes no distinction about SELECT
commands.
4) It makes the language more "regular" in that SELECT
commands are no longer special.:

Diff is an attachment because of line-wrapping. I'm new
here
so I don't know if this works. But as I said it's only 2
lines.

++ kevin

--- 
Kevin O'Gorman  (805) 650-6274  mailto:kogorman@pacbell.net
Permanent e-mail forwarder: 
mailto:Kevin.O'Gorman.64@Alum.Dartmouth.org
At school: mailto:kogorman@cs.ucsb.edu
Web: http://www.cs.ucsb.edu/~kogorman/index.html
Web: http://trixie.kosman.via.ayuda.com/~kevin/index.html

"There is a freedom lying beyond circumstance,
derived from the direct intuition that life can
be grounded upon its absorption in what is
changeless amid change"
-- Alfred North Whitehead

--- gram.y.orig	Thu May 25 15:42:17 2000
+++ gram.y	Thu Oct 19 14:34:47 2000
@@ -2585,7 +2585,6 @@
;
RuleActionList:  NOTHING				{ $$ = NIL; }
-		| SelectStmt					{ $$ = lcons($1, NIL); }
| RuleActionStmt				{ $$ = lcons($1, NIL); }
| '[' RuleActionMulti ']'		{ $$ = $2; }
| '(' RuleActionMulti ')'		{ $$ = $2; } 
@@ -2607,6 +2606,7 @@
;

RuleActionStmt: InsertStmt
+ | SelectStmt
| UpdateStmt
| DeleteStmt
| NotifyStmt

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026