Re: row numbering

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: row numbering
Date: 2005-02-28 10:06:38
Message-ID: 200502281106.38460.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-02-28 11:20:39 Re: Reading from Mysql & writting in PGsql
Previous Message Martijn van Oosterhout 2005-02-28 09:16:50 Re: Possible to run the server with ANSI/ISO string escapeing