From: Marnen Laibow-Koser Date: 2010-02-05T05:10:51+09:00 Subject: Re: Finding duplicate records before creating using FasterCS John Mcleod wrote: > >> And follow that up with a unique index in the DB. Validations are >> insufficient by themselves. >> > > The index is very unique. Something either is or isn't unique. There's no "very". :) > For example, > > YY-XXXXabc > > "YY" = year without century, > "XXXX" is an incremental integer and "abc" could be a 1,2 or 3 letter > combination. > I think you missed my point, or I missed a joke. "Unique index" is a technical DB term -- look it up if you're not familiar with the concept. > John Best, --  Marnen Laibow-Koser http://www.marnen.org marnen@marnen.org -- Posted via http://www.ruby-forum.com/.