Re: inconsistency in aliasing

what for of the syntax command +1 on order by ? maybe just wrong to given result about the error query on order by, it's BUG ?

dbalinglung

DataproSoft Developer

----- Original Message -----
From: "Louis-David Mitterrand" <vindex+lists-pgsql-general(at)apartia(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, January 14, 2009 5:46 PM
Subject: [GENERAL] inconsistency in aliasing

> 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
>