From: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.org
Subject: Re: alias not applied
Date: Fri, 09 Feb 2007 11:19:58 -0500
Message-ID: <5.2.1.1.0.20070209111848.00a70ec0@pop6.sympatico.ca> (raw)
In-Reply-To: <eqi61k$1h2h$1@news.hub.org>
At 11:04 AM 2/9/07, Sabin Coanda wrote:
>I have two queries:
>
>1. SELECT i AS "PK_ID", d AS "Deleted" FROM ( SELECT 52 AS i, true AS d ) 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.
>
>Why ?
perhaps you are running an old version - both queries produce the same
column names on my 8.2.1 system.
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: fbax@sympatico.ca
Subject: Re: alias not applied
In-Reply-To: <5.2.1.1.0.20070209111848.00a70ec0@pop6.sympatico.ca>
* 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