Skip site navigation (1) Skip section navigation (2)

Re: row numbering

From: "NTPT" <ntpt(at)centrum(dot)cz>
To: "Mike Harding" <mvh(at)ix(dot)netcom(dot)com>,"Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "josue" <josue(at)lamundial(dot)hn>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: row numbering
Date: 2005-02-28 12:58:14
Message-ID: 001e01c51d95$2a0b6690$7400a8c0@wbp1 (view raw or flat)
Thread:
Lists: 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..

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
> 
>

In response to

Responses

pgsql-general by date

Next:From: Peter EisentrautDate: 2005-02-28 13:12:15
Subject: Re: row numbering
Previous:From: Konstantin DanilovDate: 2005-02-28 12:11:45
Subject: PostgreSQL 8 compiling for Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group