Re: row numbering
От | NTPT |
---|---|
Тема | Re: row numbering |
Дата | |
Msg-id | 001e01c51d95$2a0b6690$7400a8c0@wbp1 обсуждение исходный текст |
Ответ на | row numbering (josue <josue@lamundial.hn>) |
Список | 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@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 > >
В списке pgsql-general по дате отправления: