Re: increment row number function question

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: Matthew Peter <survivedsushi(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: increment row number function question
Date: 2006-10-07 22:07:47
Message-ID: 87psd3u6do.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthew Peter <survivedsushi(at)yahoo(dot)com> writes:

> 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;

Use a sequence for the iterator.

--
Jorge Godoy <jgodoy(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-10-07 22:23:58 Re: performace review
Previous Message Alexander Staubo 2006-10-07 21:59:59 Re: performace review