> > avi=> create view z as select x as user from y; > > My expected result: an error message in CREATE VIEW > This is not a bug, it is intentional behavior. "AS" names are not > restricted to be non-reserved words.
Sure, but his point is that the resulting view has a column which is named "user" and which is not directly accessible without using double quotes. I'm not sure that would qualify as a bug, but certainly is a gotcha... - Thomas ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster