Re: inconsistency in aliasing

On Wed, Jan 14, 2009 at 3:46 AM, Louis-David Mitterrand
 wrote:
> 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 ...

A number in an order by refers to a column.

select a, b, c/d as f from table order by 3;

will order by the third field in the select list.  I'm guessing the +
1 is trying to add col 1 to a field it can't find.  doubt it's a bug,
more like a quirk.