[Top][All Lists]
[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
Re: [Gnumed-devel] Medication errors related to drug names, and the approach of TALLman lettering, Karsten Hilbert, 2011/09/05