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(at)ix(dot)netcom(dot)com>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "josue" <josue(at)lamundial(dot)hn>; <pgsql-general(at)postgresql(dot)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(at)ix(dot)netcom(dot)com>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>