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.
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? |