Skip site navigation (1) Skip section navigation (2)

Re: returned row number

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: returned row number
Date: 2005-05-06 21:00:21
Message-ID: 20050506205935.M94900@narrowpathinc.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)narrowpathinc(dot)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?

Kind Regards,
Keith

In response to

Responses

pgsql-novice by date

Next:From: Celia McInnisDate: 2005-05-07 00:24:49
Subject: Re: returned row number
Previous:From: Bruno Wolff IIIDate: 2005-05-06 21:00:16
Subject: Re: returned row number

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group