Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly