Am Freitag, 21. Januar 2005 12:58 schrieb Abdul-Wahid Paterson:
> I have the following table as a link table between my 'cats' table and
> my 'items' table. Every item must have at least one cat and exactly
> one 'master' cat.
>
> How can I create an integrity check to make sure that each item has
> exactly one 'master' cat.
It seems to me that you should merge this table into the "cats" table.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/