From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | postgresql <pgsql(at)symcom(dot)com>, Al Kirkus <Al(at)dist102(dot)k12(dot)il(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Probably simple answer |
Date: | 2001-11-06 15:41:06 |
Message-ID: | 20011106154106.46825.qmail@web13409.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think he simply wants the rows of the result set
numbered from 1 to whatever the last row is. This is
useful for referencing rows when discussing reports.
It is also an immense help when calculating a record's
statistical percentile ranking.
Doing it in a table is no problem. But how do you
create one dynamically in a select query?
I too would like to know if and how this could be
done.
Any ideas?
Andrew Gould
--- postgresql <pgsql(at)symcom(dot)com> wrote:
> I think you need to define more clearly what you
> want as an end
> product. You could create a serial column however
> there are
> possibilities of skipped numbers. Next, how do these
> 'row number'
> relate to your data when you delete a row? Do you
> expect that the
> remaining rows will re-number themselves? Is this
> 'number' a client
> id number?
>
> This sounds like you need to better define your data
> needs.
> Before anyone can help, you need to be clearer.
>
> Ted
>
> -----Original Message-----
> From: "Al Kirkus" <Al(at)dist102(dot)k12(dot)il(dot)us>
> To: pgsql-general(at)postgresql(dot)org
> Date: Thu, 01 Nov 2001 14:24:29 -0600
> Subject: [GENERAL] Probably simple answer
>
> > Hi all.
> >
> > Can anyone tell me how to get a sequential row
> count field in the
> > output of a query?
> >
> > Say I want to query for all users in a table
> sorted by lastname and
> > firstname.
> > I would like to include a column in my query
> called "rownum" which
> > would uniquely identify the row in the order of
> the query results.
> >
> > Like this:
> >
> > rownum =1 lastname=jones, firstname=john
> > rownum=2 lastname=smith, firstname=john
> >
> > etc.
> > I assume rownum should be some kind of function of
> expresion
> but I
> > don't know what.
> >
> > Something like:
> >
> > Select ???? as rownum, lastname,firstname from
> users where xxx
> =xxx
> > order by lastname, firsname.
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please
> send an
> appropriate
> > subscribe-nomail command to
> majordomo(at)postgresql(dot)org so
> that your
> > message can get through to the mailing list
> cleanly
> >
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jelle Ouwerkerk | 2001-11-06 15:53:44 | Re: data integrity (fwd) |
Previous Message | Masaru Sugawara | 2001-11-06 15:40:50 | Re: Probably simple answer |