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.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
