Re: [GENERAL] AS operator and subselect result names: PostgreSQL vs. Oracle

2003-11-02 Thread Tom Lane
[EMAIL PROTECTED] (Neil Zanella) writes: > PostgreSQL allows tables resulting from subselects to be renamed with > an optional AS keyword whereas Oracle 9 will report an error whenever > a table is renamed with the AS keyword. Furthermore, in PostgreSQL > when the result of a subselect is reference

[GENERAL] AS operator and subselect result names: PostgreSQL vs. Oracle

2003-11-02 Thread Neil Zanella
Hello, I would like to ask the about the following... PostgreSQL allows tables resulting from subselects to be renamed with an optional AS keyword whereas Oracle 9 will report an error whenever a table is renamed with the AS keyword. Furthermore, in PostgreSQL when the result of a subselect is re