| From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Selecting a daily puzzle record - which type of column to add? |
| Date: | 2017-09-18 13:42:25 |
| Message-ID: | CANu8FiweLz62ZA+kzA17PLpwLZgdmmEkGL=ou1jafYtuxdi1tQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 18, 2017 at 9:30 AM, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
> On 09/18/2017 08:17 AM, Melvin Davidson wrote:
> [snip]
>
> I don't have any specific suggestion for an additional column, other than
> Berend's idea. However, I strongly advise against the use
> of ENUM's. They can create a major problem in the event one needs to be
> removed.
>
>
> Because it will internally renumber them?
>
> --
> World Peace Through Nuclear Pacification
>
>
>Because it will internally renumber them?
No, because while there is a facility to ADD a value to an enum, there is
none to delete/drop a value.
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jehan-Guillaume (ioguix) de Rorthais | 2017-09-18 15:26:10 | Re: looking for a globally unique row ID |
| Previous Message | Ron Johnson | 2017-09-18 13:30:14 | Re: Selecting a daily puzzle record - which type of column to add? |