From: | "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | 'AS' column-alias beign ignored on outer select |
Date: | 2005-12-02 12:00:16 |
Message-ID: | 28011CD60FB1724DBA4442E38277F6264A655F@hermes.computec.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
Is this the expected behaviour?
select ID
, USK_RATING AS USK
from (
select ID
, USK_RATING
from MAIN_SONY_PS2_GAME
where ID = 101400
limit 1
)
as PRODUCT_LIST
limit 1;
id | usk_rating
--------+------------
101400 |
(1 row)
Note the column-header being labeled 'usk_rating', not 'usk'. Obviously
the 'AS' column alias of the outer select is being ignored in the
resultset.
select ID
, USK
from (
select ID
, USK_RATING AS USK
from MAIN_SONY_PS2_GAME
where ID = 101400
limit 1
)
as PRODUCT_LIST
limit 1;
id | usk
--------+-----
101400 |
(1 row)
If the column alias is being declared in the subselect, the column alias
is working.
select version();
version
----------------------------------------------------------------------
PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
Is this working as expected or is this a bug?
Kind regards
Markus
From | Date | Subject | |
---|---|---|---|
Next Message | Marian Naghen | 2005-12-02 12:11:46 | user_write_lock_oid questions |
Previous Message | Volkan YAZICI | 2005-12-02 11:55:41 | Re: encoding problem |