Search Postgresql Archives

increment row number function question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[
Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux