From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-sql@postgresql.org
Subject: Re: alias not applied
Date: Fri, 9 Feb 2007 18:35:35 +0200
Message-ID: <eqi7se$1lvd$1@news.hub.org> (raw)
References: <eqi61k$1h2h$1@news.hub.org>
<961.1171038340@sss.pgh.pa.us>
You are right. I use "PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC
gcc.exe (GCC) 3.4.2 (mingw-special)" on Windows.
But I just tried it on a newer version and it works well ( "PostgreSQL 8.1.4
on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.0.2 20051125 (Red Hat
4.0.2-8)" ).
Thanks a lot,
Sabin
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:961.1171038340@sss.pgh.pa.us...
> "Sabin Coanda" <sabin.coanda@deuromedia.ro> writes:
>> I have two queries:
>
>> 1. SELECT i AS "PK_ID", d AS "Deleted" FROM ( SELECT 52 AS i, true AS
>> ) x
>> ORDER BY i
>> 2. SELECT i AS "PK_ID", d AS "Deleted" FROM ( SELECT 49 AS i, true AS d
>> UNION SELECT 51 AS i, true AS d ) x ORDER BY i
>
>> The first returns the columns "PK_ID", "Deleted"
>> The second returns the columns i, d.
>
> Works for me:
>
> regression=# SELECT i AS "PK_ID", d AS "Deleted" FROM ( SELECT 52 AS i,
> true AS d ) x ORDER BY i;
> PK_ID | Deleted
> -------+---------
> 52 | t
> (1 row)
>
> regression=# SELECT i AS "PK_ID", d AS "Deleted" FROM ( SELECT 49 AS i,
> true AS d UNION SELECT 51 AS i, true AS d ) x ORDER BY i;
> PK_ID | Deleted
> -------+---------
> 49 | t
> 51 | t
> (2 rows)
>
> regression=#
>
> What PG version are you using, exactly?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sabin.coanda@deuromedia.ro
Subject: Re: alias not applied
In-Reply-To: <eqi7se$1lvd$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox