On 2009-01-14, Louis-David Mitterrand <[email protected]> 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 > ... > > Any idea ? > > Thanks,
if you really want to do that you can use a subselect, select score from ( select current_timestamp::abstime::int4 as score ) as foo order by score+1; but the demonstration is more interesting when the query returns several rows and the expression changes the order. select score from ( select generate_series(1,10) as score ) as foo order by score % 2 desc; -- odds and evens. :) bye. -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
