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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org