Yes, it's fine, thanks Pat !
On Aug 4, 9:59 pm, Pat Allan <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
