> 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?


Reply via email to