Dear Bruce, > Is ALSO part of the SQL standard? I can't imagine it is because there > is no rule mention.
As RULE is not in the SQL standard, ALSO is sure no part of it. > I guess if we 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. It depends on what you mean by "useful". It is certainly non essential. I just think it is "user-friendly". It took me some time to understand that rules were appended by default. With the "ALSO" keyword it would have been instantaneous. When I first looked at the syntax with the "INSTEAD" which is optionnal and without alternative, I thought that it was one of those useless keywords that are allowed so as to make SQL more English-like, as the "COLUMN" keyword in the ALTER TABLE syntax. You may argue that I did not read the documentation in depth, but I'm not sure I'm the only one;-) The change is very small (2 lines added, 2 lines changed), and upward compatible, provided that the user has not used ALSO as an object name, what seems rather unlikely IMVVHO. 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. Have a nice day, -- Fabien. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]