Also forgot to mention that this only started occuring in PostgreSQL 8.1.
Here is my SELECT version() output:
version
---------------------------------------------------------------------------=
----------------------------
PostgreSQL 8.1.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.0.120050727 (Red Hat
4.0.1-5)
On 11/23/05, Hayden James <hayden.james@gmail.com> 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".
>
>