Thanks Pat. I'm using postgresql and going with the REPLACE option (because I realized I need to replace another character as well) gives me this error (Sale is my model):
ERROR: index 'sale_core': sql_range_query: ERROR: column "sales.numbers" must appear in the GROUP BY clause or be used in an aggregate function On Mar 4, 4:23 pm, Pat Allan <[email protected]> wrote: > Hi Kyle > > Sphinx expects comma delimited values, not sure how it handles spaces - but > you can give it a shot. > > First, just try defining the attribute with an explicit type: > has numbers, :type => :multi > > If that doesn't work (TS may still be making assumptions): > has 'numbers', :as => :numbers, :type => :multi > > And finally, if Sphinx chokes on the spaces: > has "REPLACE(numbers, ' ', '')", :as => :numbers, :type => :multi > > And it's nice to see REPLACE exists in both MySQL and PostgreSQL :) > > Cheers > > -- > Pat > > On 04/03/2011, at 10:38 PM, Kyle Murphy wrote: > > > > > One field in my model looks like this: "123, 456, 789" (or any > > number). Could I index those numbers as MVAs on my model? > > > Which might look like: > > > define_indexes do > > ... > > has numbers => self.numbers.split(", ") > > end > > > Or something like that? Hopefully that makes sense. > > > Thank you for any help. > > > -- > > 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 > > athttp://groups.google.com/group/thinking-sphinx?hl=en. -- 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.
