Re: [GENERAL] Selecting a daily puzzle record - which type of columnto add?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Selecting a daily puzzle record - which type of columnto add?
Дата
Msg-id CAKFQuwZ7HVyQi7C1TyhjvRuyBLHyXg05kLrJdk=QhrwDJGwoWg@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Selecting a daily puzzle record - which type of column to add?  (Alexander Farber <alexander.farber@gmail.com>)
Список pgsql-general
On Sun, Sep 17, 2017 at 1:13 PM, Alexander Farber <alexander.farber@gmail.com> wrote:

I need to add a useful column, so that it would be easy to me to create a web script which would display today's and all past "daily puzzle" records - and wouldn't change the already published puzzles...


​Serial (i.e. integer/bigint with an sequence generator).  I would then add another table that simply stores the "last manually reviewed id" as its only record (or you could record manual reviews and take the max of that field from the table).

David J.

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

Предыдущее
От: Gmail
Дата:
Сообщение: Re: [GENERAL] looking for a globally unique row ID
Следующее
От: James Sewell
Дата:
Сообщение: [GENERAL] pg_rewind issue