Re: Surrogate keys (Was: enums) - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Surrogate keys (Was: enums)
Date
Msg-id 20060124100445.GC7766@wolff.to
Whole thread Raw
In response to Re: Surrogate keys (Was: enums)  (mark@mark.mielke.cc)
List pgsql-hackers
On Thu, Jan 19, 2006 at 09:53:11 -0500, mark@mark.mielke.cc wrote:
> 
> Yes. Representation of the DNA is probably best. But - that's a lot of
> data to use as a key in multiple tables. :-)

On a simple level, this would be a problem for twins.
There are other complications as well. People are going to have slightly
different DNA in different cells due to mutations. Though you could probably
do some averaging over a number of cells to get a single value.
For people that have had transplants, you could probably define something
for doing the sample for original material.


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Surrogate keys (Was: enums)
Next
From: Gustavo Tonini
Date:
Subject: Re: [PATCHES] postmaster/postgres merge for testing