[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] [Fwd: Re: [GPCG] Embedded Flags]
From: |
Tony Lembke |
Subject: |
Re: [Gnumed-devel] [Fwd: Re: [GPCG] Embedded Flags] |
Date: |
Fri, 11 Apr 2003 20:35:51 +1000 |
On Friday, April 11, 2003, at 12:01 PM, Horst Herb wrote:
I really would like a "shorthand" notation like:
\bp 110/80 (blood pressure 110/80)
\bp 120/90 -2w @home (blood pressure 120/90 2 weeks ago at home)
\rx cephalexin 500 mg qid * 1w
\dx appendicitis
Looks like docle ! (well, a little)
On Friday, April 11, 2003, at 09:59 AM, Karsten Hilbert wrote:
Which prompts me to realize that we need to link all those
little "comment", "note", "description" fields into one larger
generic "clinical_free_text" table that has some "type" value
associated with each snippet. So, the allergies table would
pull the elements for it's "comment" from the
"clinical_free_text" table according to its foreign key
values. And those rows in the "clinical_free_text" may or may
not be marked with types (SOAP, at the crudest useful level)
or some generic type. Thanks for jogging my brain
mysql can automatically create an fulltext index across a number of
fields.
This has worked much faster and more efficiently for me than the
previous way of creating a special table for index words (less stop
words). (which was prone to corruption, as every time a text entry was
changed an enormous number of old entries had to be deleted and new
ones added - mysql does not appear very efficient at that sort of
update)
SELECT Headline,Description, MATCH
Headline,Author,Article,Keywords,Category,Description AGAINST
('$SearchTerm') as score FROM News where MATCH
Headline,Author,Article,Keywords,Category,Description AGAINST
('$SearchTerm') ORDER BY score DESC
I could not find this functionality in postgresql : (
but it may well be there.
Regards
Tony Lembke