Re: row numbering - Mailing list pgsql-general

From Mike Harding
Subject Re: row numbering
Date
Msg-id 1109377664.86993.44.camel@bsd.mvh
Whole thread Raw
In response to Re: row numbering  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
If you insert the results of your query into a table with a serial
column, the serial column will do what you want..

On Sat, 2005-02-26 at 01:10 +0100, Peter Eisentraut wrote:
> josue 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.
>
--
Mike Harding <mvh@ix.netcom.com>


pgsql-general by date:

Previous
From: Rick.Casey@colorado.edu
Date:
Subject: Re: basic trigger using OLD not working?
Next
From: Ron Mayer
Date:
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.