Re: inconsistency in aliasing

Lennin Caro wrote:

> select score,score+1 as score2 from (
> select current_timestamp::abstime::int4 as score)
> order by score2

That additional score2 is not needed in the select output.

This works just fine:

=> select score from (select current_timestamp::abstime::int4 as score)
subsel order by score+1;

The point is that the subselect makes "score" available as a valid
expression to the upper select.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org