On Mon, 13 Jun 2016 19:11:29 +0000
"Drago, William @ CSG - NARDA-MITEQ" <william.dr...@l-3com.com> wrote:
> I need UNIQUE(B, C) only when E=0.
A conditional constraint is evidence that you have two kinds of things
represented in one table: those E=0 types that are identified by {B,C},
and the rest. They're represented in a single table because they
seem to have the same columns, although the E=0 types don't need an E
column.
A better solution might be to separate the two types into to two
tables, each with its own constraints, and use a UNION to represent
them as one.
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
