increment row number function question - Mailing list pgsql-general

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.