increment row number function question

Hello. I need a way to return an iterator result as a column.... eg,

SELECT increment() as ii, some_col from some_tbl order by some_col desc limit 50;

ii | some_col
----+----------
1 | zest
2 | test
3 | nest
4 | fest
[...]

How can I acheive those results? Thanks for any help.

---------------------------------
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.