Re: surrogate key or not? - Mailing list pgsql-sql

From Kenneth Gonsalves
Subject Re: surrogate key or not?
Date
Msg-id 04072711335024.01150@thenilgiris.com
Whole thread Raw
In response to Re: surrogate key or not?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-sql
On Tuesday 27 July 2004 02:04 am, Karsten Hilbert wrote:

> One thing we ARE looking for in our records is the ability to
> find groups of patients by arbitrary criteria since one day
> I'll have to find all my patients whose father took a statine,
> whose second-born child suffered a bout of neutropenia 2 weeks
> after birth and who started being on the pill at age 14.
> Because they'll have a 3fold increased risk of lung embolus.
> Unless monitored for clotting factors every 6 months. Which I
> will have to do from now on. Get my point ?  :-)

couldnt you do something like, let them write the 'long flaky text', and at 
the same time mark a certain number of key words or key phrases which could 
be stored and retrieved?

-- 
regards
kg

http://www.onlineindianhotels.net - hotel bookings reservations in over 4600 
hotels in India
http://www.ootygolfclub.org


pgsql-sql by date:

Previous
From: sad
Date:
Subject: surrogate keys and replication.
Next
From: Markus Bertheau
Date:
Subject: Re: surrogate key or not?