Re: [SQL] Unique constraints for a list

2003-08-29 Thread Richard Huxton
On Friday 29 August 2003 06:50, Anuradha Ratnaweera wrote: [snipped description of groups consisting of unique lists of members, i.e. group A contains (1,2,3) so B can't contain the same] I was looking at something almost identical a few days ago. > Then we added a unique string field to t3 whic

[SQL] Unique constraints for a list

2003-08-29 Thread Anuradha Ratnaweera
Hi all, o We have a table t1 which has a primary key id and other fields. (say, 10 rows with ids 1 to 10). o We need to group rows (unordered, and arbritrary size) in t1 and assign a unique id to each group. (e.g.: {1, 3, 4} is group 1, {1, 5} is group 2 etc.) o A group shouldn't change