Skip site navigation (1) Skip section navigation (2)

Re: Surrogate keys

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Surrogate keys
Date: 2006-01-21 03:16:26
Message-ID: m3r772s22d.fsf@mobile.int.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> On 1/19/06, Pollard, Mike <mpollard(at)cincom(dot)com> wrote:
>> Martijn van Oosterhout wrote:
>>
>> > Please provides natural keys for any of the following:
>> >
>> > - A Person
>> > - A phone call: (from,to,date,time,duration) is not enough
>> > - A physical address
>> > - A phone line: (phone numbers arn't unique over time)
>> > - An internet account: (usernames not unique over time either)
>>
>> Ahh, a challenge.  Hmm, not sure about all of them, but here goes:
>>
>> A Person - well, you could use a bit map of their fingerprints, or maybe
>> their retinal scan.  Of course, that could change due to serious injury.
>> Maybe some kind of representation of their DNA?
>
> Unless the person in question happens to be a chimera (yes, they do exist).
>
> ;-)

Yeah, I saw that episode of CSI!  :-)
-- 
"cbbrowne","@","gmail.com"
http://linuxdatabases.info/info/lsf.html
"Cat's motto: No matter what you've done wrong, always try to make it
look like the dog did it." -- Unknown

In response to

Responses

pgsql-hackers by date

Next:From: Rick GiggerDate: 2006-01-21 03:28:47
Subject: Re: panic on 7.3
Previous:From: Rick GiggerDate: 2006-01-21 03:11:01
Subject: Re: panic on 7.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group