Mailing List Archive


Back to the month index Back to the list index
David J. Hughes (bambi@Hughes.com.au)
Tue, 13 Apr 1999 22:19:57 +1000 (EST) 

Date: Tue, 13 Apr 1999 22:19:57 +1000 (EST)
From: "David J. Hughes" <bambi@Hughes.com.au>
Subject: Re: un-enforced "unique" indices
Message-ID: <Pine.BSF.3.96.990413221936.485D-100000@fawn.Hughes.com.au>

On Mon, 12 Apr 1999, James E. Harrell wrote:

> Here is a test example. The idea is that there are several "groups"
> defined. Each group can have several categories, but all categories
> within a group must be unique. This is enforced by the unique index on
> (groupID, category_name). This also allows two different groups to have
> categories by the same name.

OK, we'll look into it.

Bambi
...