Re: Bug #545: Keyword USER not detected in CREATE VIEW - Mailing list pgsql-bugs

> >   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