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

[Jim Busser]

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

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));


-- Jim