Incorrect column identifer using AS in SELECT statement on a VIEW. - Mailing list pgsql-bugs

From Hayden James
Subject Incorrect column identifer using AS in SELECT statement on a VIEW.
Date
Msg-id f9cd33b40511222320w3c5761ceo8b6044cf1c48b79@mail.gmail.com
Whole thread Raw
Responses Re: Incorrect column identifer using AS in SELECT statement on a VIEW.  (Hayden James <hayden.james@gmail.com>)
Re: Incorrect column identifer using AS in SELECT statement on a VIEW.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Incorrect column identifer using AS in SELECT statement on a VIEW.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2065: Problem with language conversion in pg_dump
Next
From: Harald Armin Massa
Date:
Subject: Re: strange disappearence of postgres file