Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> AFAICS removing columns from the inner query because they have duplicate
> names would violate the SQL spec, so it's not going to happen.
That's really what I was asking I guess. Does the spec require the current
behaviour.
An alternative would be some way to explicitly remove columns from a result
set.
Something like
SELECT a+1 AS a, b+1 AS b, * EXCEPT (a,b)
FROM (SELECT 1 AS a, 2 as b, 3 as c)
--
greg