Re: Probably simple answer - Mailing list pgsql-general

From Andrew Gould
Subject Re: Probably simple answer
Date
Msg-id 20011109010116.60146.qmail@web13404.mail.yahoo.com
Whole thread Raw
In response to Re: Probably simple answer  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Thanks.  Sometimes there's just no getting around a
little work.  :-)

Andrew Gould

--- Peter Eisentraut <peter_e@gmx.net> wrote:
> Andrew Gould writes:
>
> > 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?
>
> It's not easily possible.
>
> Even if you were to write a server-side function
> that would implement such
> a counter, there is no guarantee that the rows would
> be returned in the
> order that the function is called in.  (Depending on
> how you express the
> query it can be very likely, but there is no
> guarantee.)
>
> It gets worse if you use ORDER BY or DISTINCT.  Then
> the problem amounts
> to adding a column to the result set after sorting,
> which is not possible
> in the SQL query model.
>
> So by far the easiest choice is to keep this counter
> in the client
> application as you loop through the result set.
>
> --
> Peter Eisentraut   peter_e@gmx.net
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org


__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] PostgreSQL v7.2b2 Released
Next
From: "PIPER,JIM (A-SantaClara,ex1)"
Date:
Subject: MS Client ODBC question