Re: [Gnumed-devel] [Fwd: Re: [GPCG] Embedded Flags]

[Tony Lembke]

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