On Aug 23, 2007, at 14:25 , Tom Lane wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:
I just don't see the ability to omit the alias in a query with
only one
subquery (the only circumstances under which it would be safe to
do so) as
any significant gain in fuctionality.
Why do you think it'd be restricted to only one subquery?
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.
How about something like gensym? One alias you could always use and
be guaranteed it would give a unique value. Still provide the alias,
but don't have to think about name collisions.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
