Re: increment row number function question - Mailing list pgsql-general

From Jorge Godoy
Subject Re: increment row number function question
Date
Msg-id 87psd3u6do.fsf@gmail.com
Whole thread Raw
In response to increment row number function question  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-general
Matthew Peter <survivedsushi@yahoo.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@gmail.com>

pgsql-general by date:

Previous
From: Alexander Staubo
Date:
Subject: Re: performace review
Next
From: "Joshua D. Drake"
Date:
Subject: Re: performace review