On Wed, Jan 14, 2009 at 3:46 AM, Louis-David Mitterrand <vindex+lists-pgsql-gene...@apartia.org> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
