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" <[EMAIL PROTECTED]>
To: "Peter Eisentraut" <[EMAIL PROTECTED]>
Cc: "josue" <[EMAIL PROTECTED]>; <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 <[EMAIL PROTECTED]>
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
