Incorrect column identifer using AS in SELECT statement on a VIEW.

Поиск
Список
Период
Сортировка
If I create a normal table and a normal view that queries that table I get
incorrect results when I query the view using the AS alias in the select
statement.  For example, if I create the following objects:

CREATE TABLE Test1( col1 VARCHAR(200) );
CREATE VIEW Test2 AS SELECT col1 FROM Test1 ORDER BY col1;

then I do a SELECT col1 AS something FROM Test2;  The column identifier
comes back as "col1" instead of "something".

В списке pgsql-bugs по дате отправления: