Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> select * from (select 1 as foo, 2 as foo) as x(foo1, foo2);
How is this different than simply listing all the columns instead of the "*"?
I still have the maintenance problem of having to edit the outer query every
time the list of columns from the inner query changes.
--
greg