From: email@...
Date: 2006-11-14T17:25:18+09:00
Subject: Re: Modelling Unique Collections in Rails/SQL

> > Any ideas ?Personally, I wouldn't bother.

Obviously not the answer I was looking for.
:-)

>It is entirely possible that a band
> assumes the identical lineup twice in its history. I'd presume your
> model also holds dates of when a lineup was formed / disbanded, it
> should be sufficient to verify overlap of those dates. I

Unfortunately Line Ups don't have start / end dates. Its more complex /
simpler that that.
LineUps change all the the time from gig to gig, recording to to
recording so I'm thinking a LineUps should just be a unique collection
of People tied to a band_id

How can that be modelled in SQL ?

A unique composite field of people ids ?

Tony