Re: serial number in output

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: serial number in output
Дата
Msg-id 9e4684ce0510280741t3d86e7ccu7ac2664a6f7c3c3c@mail.gmail.com
обсуждение исходный текст
Ответ на serial number in output  ("alessandra de gregorio" <adegregorio@fgscapital.com>)
Список pgsql-general
Дерево обсуждения
On 10/28/05, alessandra de gregorio <adegregorio@fgscapital.com> wrote:
What function should I use to get a serial number, together with my results,
from a query?
Ex. Of output I want:
1       ooo     pp      ij
2       hou     joo     iu
3       bhi     ft      yh
Basically, I would like to have one column with integers, from 1 onwards, no
matter how many tables I join in, or the data that I get back.

first of all - this is job for client program to do the numbering, but if you really insist on having this in database (why?) then just use temporary sequence.

depesz

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

Предыдущее
От: Douglas McNaught
Дата:
Сообщение: Re: Function written in C, hangs on one machine and not another...
Следующее
От: CG
Дата:
Сообщение: Re: Function written in C, hangs on one machine and not another...