On Aug 23, 2007, at 14:25 , Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> 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