Re: row numbering

> If you insert the results of your query into a table with a serial
> column, the serial column will do what you want..

Plus add a huge overload... ?

Having some sort of line numbering in result query  would be nice...





----- Original Message -----
From: "Mike Harding" <mvh@ix.netcom.com>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "josue" <josue@lamundial.hn>; <pgsql-general@postgresql.org>
Sent: Saturday, February 26, 2005 1:27 AM
Subject: Re: [GENERAL] row numbering


> 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>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>