version
-------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.0.1 20050727 (Red Hat 4.0.1-5)
On 11/23/05, Hayden James <[EMAIL PROTECTED]> wrote:
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".
