| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: alias not applied |
| Date: | 2007-02-09 16:25:40 |
| Message-ID: | 961.1171038340@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> writes:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sabin Coanda | 2007-02-09 16:35:35 | Re: alias not applied |
| Previous Message | Frank Bax | 2007-02-09 16:19:58 | Re: alias not applied |