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 -~----------~----~----~----~------~----~------~--~---
