Re: returned row number

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.