Sufficient Primary Key?

From: Dan Delaney <dionysos(at)dionysia(dot)org>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Sufficient Primary Key?
Date: 1998-07-24 15:06:48
Message-ID: Pine.BSF.3.96.980724110250.17263E-100000@dionysia.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello all.
I'm working on a library catalog and trying to decide what to use
for the primary key for the authors. Do you think that the first
three letters of first and last name with the birth year would be
sufficient (e.g., Alan Watts would be ALAWAT1915). So, essentially,
do you think there there would ever be two authors with the same
first and last name AND the same birth year? I really don't want to
inject the middle name into there because I can't find the middle
name (or even middle initial) of most authors!
Thanks.
--Dan

-----------------------------------------------------------------------
Daniel G. Delaney The Louisville Times Chorus
Dionysos(at)Dionysia(dot)org www.LouisvilleTimes.org
www.Dionysia.org/~dionysos/ Dionysia Design
ICQ Number: 8171285 www.Dionysia.com/design/
-----------------------------------------------------------------------
I doubt, therefore I might be.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Delaney 1998-07-24 15:09:59 What about Unicode?
Previous Message Brett W. McCoy 1998-07-24 14:56:29 Re: [GENERAL] How about this LOGO?