[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.

Tony Lembke

reply via email to

[Prev in Thread] Current Thread [Next in Thread]