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

From David G. Johnston
Subject Re: [GENERAL] Selecting a daily puzzle record - which type of columnto add?
Date
Msg-id CAKFQuwZ7HVyQi7C1TyhjvRuyBLHyXg05kLrJdk=QhrwDJGwoWg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Selecting a daily puzzle record - which type of column to add?  (Alexander Farber <alexander.farber@gmail.com>)
List 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 by date:

Previous
From: Gmail
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID
Next
From: James Sewell
Date:
Subject: [GENERAL] pg_rewind issue