Re: [SQL] surrogate key or not?

2004-07-27 Thread Kenneth Gonsalves
On Wednesday 28 July 2004 06:59 am, Iain wrote: > > 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? > > I was thinking along similar lines. On one ha

Re: [SQL] surrogate key or not?

2004-07-27 Thread Iain
> > 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 bei

Re: [SQL] surrogate key or not?

2004-07-27 Thread Markus Bertheau
Ð ÐÑÐ, 23.07.2004, Ð 09:57, Kenneth Gonsalves ÐÐÑÐÑ: > also, how did you get that neatly formatted output of the schema? This is postgresql_autodoc: http://www.rbt.ca/autodoc/ -- Markus Bertheau <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1

Re: [SQL] surrogate key or not?

2004-07-27 Thread Kenneth Gonsalves
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 neutr

[SQL] surrogate keys and replication.

2004-07-27 Thread sad
Josh, I agree to treat this case as a (1) convinence. But it is still very cpecific, more than just simplifying FKs And you have said about general GUID problem. Let we disscuss this problem ? I hope to here good ideas from you again. Now I solve the GUID problem, with one sequence of IDs on the