From: Brett W. McCoy <bmccoy@lan2wan.com>
To: Stuart Rison <stuart@ludwig.ucl.ac.uk>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Primary keys: can they be alphanumerical?
Date: Mon, 6 Jul 1998 09:25:33 -0400 (EDT)
Message-ID: <Pine.BSI.3.91.980706092124.19636B-100000@access1.lan2wan.com> (raw)
In-Reply-To: <l03110707b1c67506245f@[128.40.242.190]>
On Mon, 6 Jul 1998, Stuart Rison wrote:
> I would like to know what is the general concensus on having alphanumerical
> primary keys.
I use alphanumeric primary keys all the time. I keep large databases
with FDA regulatory information in them, and the FDA assigned approval
number, usually a letter, followed by two digits indicating the year of
approval or the type of approval (like for a generic drug), followed by four
digits indicating the sequence of apporval for that year. I use this
same key as a a foreign key for, say, patent records, which is usuallu a
one-to-many join.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"The Number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: bmccoy@lan2wan.com, stuart@ludwig.ucl.ac.uk
Subject: Re: [SQL] Primary keys: can they be alphanumerical?
In-Reply-To: <Pine.BSI.3.91.980706092124.19636B-100000@access1.lan2wan.com>
References: <l03110707b1c67506245f@[128.40.242.190]> <Pine.BSI.3.91.980706092124.19636B-100000@access1.lan2wan.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox