Re: row numbering - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: row numbering
Date
Msg-id 200502281106.38460.peter_e@gmx.net
Whole thread Raw
In response to Re: row numbering  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Karsten Hilbert wrote:
> > > is there a way return a column with the row number automatically
> > > generated according the way the rows were processed by the query.
> >
> > No, but you can easily keep a counter in the client.
>
> How, then, do I do it if I "need" the "row number" in a view ?

Keep the counter in the client as you process or display the result
rows.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: "Sean Davis"
Date:
Subject: Re: Reading from Mysql & writting in PGsql
Next
From: "Markus Wollny"
Date:
Subject: Problems with pgcrypto and special characters