[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 09:34:16 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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