inconsistency in aliasing - Mailing list pgsql-general

Hi,

This works:

    critik=# select current_timestamp::abstime::int4 as score order by score;

This doesn't:

    critik=# select current_timestamp::abstime::int4 as score order by score + 1;
    ERROR:  column "score" does not exist
    LINE 1: ...urrent_timestamp::abstime::int4 as score order by score + 1 ...

Any idea ?

Thanks,

--
http://www.critikart.net