On 2007-08-16, at 3:15 AM, Paul Lynch wrote: > Is there a way in Ferret to do something akin to SQL's "SELECT > DISTINCT" > query? I have a table with multiple columns, and I would like to > search just a couple of them (but index others for other kinds of > searches on the table). The two columns I want to search do not have > unique values, because the other columns finish specifying the record. > Is there a way to avoid picking up the duplicates in the result list?
Paul, i think i don't get your point.. If you search for something in ferret, you will never get duplicates in your result set (meaning ferret documents). However, your columns (fields in ferret terms) might have the same value for several documents. So you just want to get the different field values for your search, but not the actual ferret documents? Maybe you can give us a small example of your data, searches, actual results and what you would like to have as a result :-) Ben _______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
