Update with a Repeating Sequence

Поиск
Список
Период
Сортировка
От Bill Thoen
Тема Update with a Repeating Sequence
Дата
Msg-id 48F4C317.4040305@gisnet.com
обсуждение исходный текст
Ответы Re: Update with a Repeating Sequence
Re: Update with a Repeating Sequence
Список pgsql-general
I've got a table with repeated records that I want to make unique by
adding a sequence code of 0,1,2,...,n for each set of repeated records.
Basically, I want to turn:
 field_id | seq
----------+-----
        1 |   0
        2 |   0
        3 |   0
        3 |   0
        3 |   0
        4 |   0
        4 |   0
        5 |   0
        6 |   0
into:
 field_id | seq
----------+-----
        1 |   0
        2 |   0
        3 |   0
        3 |   1
        3 |   2
        4 |   0
        4 |   1
        5 |   0
        6 |   0

What's the best way to that?

TIA,
- Bill Thoen


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