gnumed-devel
[Top][All Lists]
Advanced

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

Re: [Gnumed-devel] Might ref.consumable substances need to allow an amou


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Might ref.consumable substances need to allow an amount of zero?
Date: Mon, 5 Sep 2011 12:38:27 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

On Mon, Sep 05, 2011 at 02:22:56AM -0700, Jim Busser wrote:

> > since units can be intended to mean something different
> > depending on case.
> 
> Yes, the above is more technically correct, except
> duplicates will end up resulting on account of (for example)
> the Canadian data is supplied entirely in upper case.

Which speaks to the quality of the data source. It delivers
simply wrong data.

>       MG
> 
> which literally should be Mega-Gigas !*^!!!

Which isn't even a unit but rather only an (invalid)
magnitude prefix.

> whereas the risk of duplicates (which will be unable to be
> pruned, on account of them getting variously keyed into
> patient records) is a real one.

Unless, of course, one desires to use proper case in which
case the wrong casing *can* eventually be pruned.

> Can we accept to make the constraint
> 
>       unique(upper(description), amount, upper(unit))

Why not - at insertion of substances - make the existence
check case insensitive ?

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]