Err, so did you find a solution? :) Not sure from all the emails.
-- Pat On 03/08/2009, at 9:50 PM, Pierre Valade wrote: > > Oups... my mistake. > :group_clause => "@geodist asc" works as expected.... I guess that > Sphix takes the first result in every group, this group being sorted > by order and takes this as a reference when accessing an internal > attribute for sorting the group. > > Thanks > > On Aug 3, 10:27 pm, Pierre Valade <[email protected]> wrote: >> Sorry, but in fact the :group_clause => "@geodist asc" doesn't >> work... >> (which is logic)... >> >> My situation is that I search in a table Publications that can have a >> lot of same place_id >> >> And I want to order the Publications using geodist and having only >> one >> publication per place_id >> >> Thanks, >> Pierre >> >> On Aug 3, 10:20 pm, Pierre Valade <[email protected]> wrote: >> >>> Pat, >> >>> I've checked the documentation. >> >>> I have provided a :group_clause => "@geodist asc" option and things >>> are great. >> >>> I don't know what Sphinx takes as the @geodist for a whole group but >>> it seems to work fine. >> >>> Pierre >> >>> On Aug 3, 10:13 pm, Pierre Valade <[email protected]> wrote: >> >>>> Hi Pat, >> >>>> I've tried to group the results. >> >>>> But I want to use it with :geo options and :sort "@geodist asc" and >>>> the results, when using :group, are not sorted anymore. >> >>>> On Aug 3, 9:52 pm, Pat Allan <[email protected]> wrote: >> >>>>> You shouldn't be getting multiple instances of the same record >>>>> back in >>>>> a search... unless you're using STI, as that's still not perfect >>>>> yet. >> >>>>> If you want to ensure one record for each value of a given >>>>> attribute, >>>>> then you'll need to group the >>>>> results.http://freelancing-god.github.com/ts/en/searching.html(seethelast >>>>> section) >> >>>>> -- >>>>> Pat >> >>>>> On 03/08/2009, at 8:15 PM, Pierre Valade wrote: >> >>>>>> Hello, >> >>>>>> Is there a way to select only distinct results from a Sphinx >>>>>> search, >>>>>> as that is possible with mysql ? >> >>>>>> Thanks, >>>>>> Pierre > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
