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/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
