Re: [Gnumed-devel] Data pack for ICD-9 :-)

[Karsten Hilbert]

On Mon, Sep 26, 2011 at 05:47:49PM -0700, Jim Busser wrote:

> But ref.icd9 allows duplicates on
> 
>       fk_data_source, code, term
> 
> so what you are indicating (I think) is that we should allow in this table
> 
>       fk to icd9 where lang = 'en', '401', 'Essential hypertension'
>       fk to icd9 where lang = 'fr', '401', 'Hypertension artérielle 
> essentielle'
> 
> but not
> 
>       fk to icd9 where lang = 'en', '401', 'Essential hypertension'
>       fk to icd9 where lang = 'en', '401', 'Essential hypertension'
>       fk to icd9 where lang = 'en', '401', 'Essential hypertension'
>       fk to icd9 where lang = 'en', '401', 'Essential Hypertension'
>       fk to icd9 where lang = 'en', '401', 'Essential Hypertension'
>       fk to icd9 where lang = 'en', '401', 'essential hypertension'
>       fk to icd9 where lang = 'en', '401', 'ESSENTIAL HYPERTENSION'

Yes.

> so we want
> 
>       unique(fk_data_source, UPPER(code), UPPER(term))
> 
> and in fact should want
> 
>       unique(fk_data_source, UPPER(code))

Done.

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