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-gene...@apartia.org> To: <pgsql-general@postgresql.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 >
