Re: Selecting a daily puzzle record - which type of column to add?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Selecting a daily puzzle record - which type of column to add?
Date: 2017-09-18 01:43:00
Message-ID: CAKFQuwZ7HVyQi7C1TyhjvRuyBLHyXg05kLrJdk=QhrwDJGwoWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Sep 17, 2017 at 1:13 PM, Alexander Farber <
alexander(dot)farber(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James Sewell 2017-09-18 04:36:09 pg_rewind issue
Previous Message Gmail 2017-09-18 00:34:27 Re: looking for a globally unique row ID