Re: [Gnumed-devel] Might ref.consumable substances need to allow an amount of zero?

[Karsten Hilbert]

On Sun, Sep 04, 2011 at 09:36:09PM -0700, Jim Busser wrote:

> should better be case-insensitive? e.g.
> 
>       alter table ref.consumable_substance
>       add constraint ref_consumable_uniq_subst_amount_unit
>               unique(upper(description), amount, upper(unit));

Or rather:

        alter table ref.consumable_substance
        add constraint ref_consumable_uniq_subst_amount_unit
                unique(upper(description), amount, unit);

since units can be intended to mean something different
depending on case.

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