Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
