Hayden James <[EMAIL PROTECTED]> writes:
> 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.
Turns out it depends on the plan used for the view, but in the
particular case you were exer
Hayden James <[EMAIL PROTECTED]> writes:
> then I do a SELECT col1 AS something FROM Test2; The column identifier
> comes back as "col1" instead of "something".
Hmm, we fixed a problem just like this last month ... seems we missed
some cases though ...
regards, tom lane
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-r
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
