From: | Hayden James <hayden(dot)james(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Incorrect column identifer using AS in SELECT statement on a VIEW. |
Date: | 2005-11-23 07:24:56 |
Message-ID: | f9cd33b40511222324r66855998mf00d68feb3103390@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(dot)james(at)gmail(dot)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".
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Qingqing Zhou | 2005-11-23 08:09:29 | Re: strange disappearence of postgres file |
Previous Message | Harald Armin Massa | 2005-11-23 07:24:52 | Re: strange disappearence of postgres file |