Re: row numbering

Поиск
Список
Период
Сортировка
От Jay Guerette
Тема Re: row numbering
Дата
Msg-id 4b9601ce0502272145662e21ef@mail.gmail.com
обсуждение исходный текст
Ответ на Re: row numbering  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: row numbering  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
OT: You have other database issues: http://www.gnumed.org/

<snip>
error
insert into WebLog values(586,31,"2005-02-28","<ip addr removed>")
Duplicate entry '2005-02-28' for key 2
</snip>

On Sun, 27 Feb 2005 18:08:02 +0100, Karsten Hilbert
<Karsten.Hilbert@gmx.net> 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.
> How, then, do I do it if I "need" the "row number" in a view ?
>
> Karsten
> --
> GPG key ID E4071346 @ wwwkeys.pgp.net
> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>

В списке pgsql-general по дате отправления:

Предыдущее
От: Ragnar Hafstað
Дата:
Сообщение: Re: Referencing created tables fails with message that
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Referencing created tables fails with message that