Posted by Steve Auerbach on October 22, 2005 at 14:36:19:
In Reply to: Re: Multi-Keyed File, continued...> posted by Steve Auerbach on October 22, 2005 at 08:07:32:
Secondary indices are not unique.
That means you can not say "Get me the record with city.name EQ "Sebastopol". You can say "Get me A record with city.name EQ "Sebastopol" Now Get another and another and another.
Or, in SQL, SELECT WHERE 'CityName' = 'Sebastopol'. BUT, SQL gives you a new table with all the records that match. All the records.
We may have to adjust our thinking and learn to be SQL programmers after all.