Postgres Pro
Downloads
Home   >   mailing lists

alias not applied - Mailing list pgsql-sql

From Sabin Coanda
Subject alias not applied
Date
Msg-id eqi61k$1h2h$1@news.hub.org
Whole thread Raw
Responses Re: alias not applied  (Frank Bax <fbax@sympatico.ca>)
Re: alias not applied  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Hi all,

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 ?

TIA,
Sabin

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: dynamic sql
Next
From: Frank Bax
Date:
Subject: Re: alias not applied