So having thought about this a little more, it seems like once you create a result set with identically-named columns, those columns are effectively crippled. In that they can be viewed (via SELECT *), but not referenced, used or acted upon in any way. Still just wanting to confirm this is/is not the case. Thanks!
I'm not really following the intent of the question but if your client API allows for column references by position instead of name you can still distinguish between them, too.
In subqueries or CREATE TABLE AS, no, the system, is going to force you to differentiate them since all SQL references are by name.
David J.
