On Fri, 1 Oct 2004, Bernd Helmle wrote:
While having trouble extending the CREATE VIEW grammar i discovered this:
[EMAIL PROTECTED]:yomama #= CREATE VIEW vtest as SELECT * from abteilung WITH; CREATE VIEW
I'm not sure what in particular you're getting at. Although technically WITH is a reserved word and as such shouldn't be usable as a correlation name for abteilung, we generally try to limit those restrictions whenever possible.
Hmm, okay, it wasn't clear to me that WITH is an allowed table alias name. Looking in the unreserved keyword map in gram.y i see WITH there.
My current work is to extend the CREATE VIEW statement with the WITH [ CASCADE | LOCAL ] CHECK OPTION, so i wondered first, why WITH is not a reserved word.
Thanks for your reply.
--
Bernd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
