[Top][All Lists]
[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