On Wed, Jan 14, 2009 at 12:06:47PM +0100, A. Kretschmer wrote: > In response to 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 ? > > Yes, you can't use the alias in the ORDER BY. Use the real column-name. > > select current_timestamp::abstime::int4 as score order by > current_timestamp::abstime::int4;
Did you try "select current_timestamp::abstime::int4 as score order by score;" ? This seems to be an "order by <alias>" -- 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
