Re: returned row number

On Fri, May 06, 2005 at 17:00:21 -0400,
  Keith Worthington <keithw@narrowpathinc.com> wrote:
> On Fri, 6 May 2005 16:00:16 -0500, Bruno Wolff III wrote
> > On Fri, May 06, 2005 at 15:45:02 -0400,
> >   Keith Worthington <keithw@narrowpathinc.com> wrote:
> > > Hi All,
> > >
> > > I have a quick question.  Is there a simple way to access
> > > the returned record number?
> > >
> > > I want to be able to do something like
> > >
> > > SELECT record AS record_no,
> > >        column1,
> > >        column2
> > >   FROM table1
> > >  WHERE column2 < 100
> > >  ORDER BY column1;
> > >
> > > record_no | column1 | column2
> > > ----------+---------+---------
> > > 1         | A       | 1.75
> > > 2         | F       | 93
> > > 3         | M       | 12.5
> > > 4         | N       | 0
> > > 5         | Q       | 57.6
> >
> > Normally the best thing to do is have the application count.
> > You can use a subquery to get the counts, but it will be a
> > lot slower. You could also write a set returning function
> > to do this.
> >
>
> This query is actually in a SRF.
>
> Can you suggest how to proceed?

If you are looping through the results in the SRF, you should be able to
increment a counter as you are doing that (unless the language is SQL).
I don't do enough of that to be able to write an example off the top
of my head, but it shouldn't be hard to figure out.