[GENERAL] inconsistency in aliasing

[Louis-David Mitterrand]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general