"Sabin Coanda" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
