Tom,
> As long as you take care that the subquery's column names don't match
> any other ones in the query, you don't *need* an alias for it ---
> there'll be no need to qualify the column names. This extends just
> fine to multiple subqueries.
Oh, hmmm. I was thinking this would somehow be more of an issue with
anonymous subqueries, but it isn't really. You can still duplicate column
names in named subqueries.
So, never mind that.
I still don't see it as terrifically useful functionality, given that it's
just saving you 4 keystrokes ...
--
Josh Berkus
PostgreSQL @ Sun
San Francisco