gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Medication errors related to drug names, and the appr


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Medication errors related to drug names, and the approach of TALLman lettering
Date: Mon, 5 Sep 2011 13:22:36 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

On Mon, Sep 05, 2011 at 01:55:34AM -0700, Jim Busser wrote:

> The attached will now find and replace the first occurrence of any of these 
> frequently-confused drugs in each of the descriptions in
> 
>       ref.branded_drug
>       ref.consumable_substance

Across-loanguages matching can be improved by ignoring
trailing e's if that can be effected and still true to the
purpose (reformatted for clarity):

        UPDATE ref.branded_drug SET
                description = overlay (
                        description placing 'acetaZOLAMID' from 
POSITION(upper('acetaZOLAMID') in upper(description))
                )
        WHERE
                POSITION(upper('acetaZOLAMID') in upper(description)) > 0
        ;

Some streamlining of upper() can help if technically
affordable:

        UPDATE ref.branded_drug SET
                description = overlay (
                        description placing 'acetaZOLAMID' from 
POSITION('ACETAZOLAMID' in upper(description))
                )
        WHERE
                POSITION('ACETAZOLAMID' in upper(description)) > 0
        ;

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



reply via email to

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