Re: Surrogate keys (Was: enums)

Поиск
Список
Период
Сортировка
От mark@mark.mielke.cc
Тема Re: Surrogate keys (Was: enums)
Дата
Msg-id 20060119145311.GA2380@mark.mielke.cc
обсуждение исходный текст
Ответ на Re: Surrogate keys (Was: enums)  ("Pollard, Mike" <mpollard@cincom.com>)
Ответы Re: Surrogate keys (Was: enums)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: Surrogate keys (Was: enums)  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-hackers
On Thu, Jan 19, 2006 at 09:37:12AM -0500, Pollard, Mike 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?

Yes. Representation of the DNA is probably best. But - that's a lot of
data to use as a key in multiple tables. :-)

> A physical address - how about longitude/latitude/height from sea level?

Planet? Solar system? Galaxy? Universe? :-)

I agreed with what you had to say (the stuff I deleted). Just felt
like being funny. Not sure if I'm successful. Hehe...

Cheers,
mark

-- 
mark@mielke.cc / markm@ncf.ca / markm@nortel.com     __________________________
.  .  _  ._  . .   .__    .  . ._. .__ .   . . .__  | Neighbourhood Coder
|\/| |_| |_| |/    |_     |\/|  |  |_  |   |/  |_   | 
|  | | | | \ | \   |__ .  |  | .|. |__ |__ | \ |__  | Ottawa, Ontario, Canada
 One ring to rule them all, one ring to find them, one ring to bring them all                      and in the darkness
bindthem...
 
                          http://mark.mielke.cc/



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Pollard, Mike"
Дата:
Сообщение: Re: Surrogate keys (Was: enums)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: restrict column-level GRANTs to a single relation?