Received: from access1.lan2wan.com (bmccoy@access1.lan2wan.com [205.177.8.10]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA07993 for ; Mon, 6 Jul 1998 08:56:29 -0400 (EDT) Received: (from bmccoy@localhost) by access1.lan2wan.com (8.8.5/Config By A.D.Simmons) id JAA19876; Mon, 6 Jul 1998 09:25:34 -0400 (EDT) Date: Mon, 6 Jul 1998 09:25:33 -0400 (EDT) From: "Brett W. McCoy" To: Stuart Rison cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Primary keys: can they be alphanumerical? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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