How is the column serialised? As YAML? JSON? Ruby's marshalled objects? Something else?
Mind you, for all of those that I've listed, the answer is the same - it's not possible. However, if you're storing a list of integers (timestamps or otherwise), comma separated, then it's possible: has "table.all_times", :as => :all_times, :type => :multi It's also worth trying this approach, but not sure if Thinking Sphinx will try to transform the column unnecessarily. Try it anyway, as it's the cleaner solution: has all_times, :type => :multi Cheers -- Pat On 07/12/2011, at 5:25 AM, jdutil wrote: > Is it possible to define an index on a serialized column? How would > you go about doing this? > > More specifically I would like to search a serialized Array of Time > objects or Integer Timestamps. Then only return records, which have a > Time or Timestamp taking place within a certain months time range > within the serialized array. > > I'm trying to find the best way to store occurrences of recurring > events, and then only find the events taking place within that month. > If this can be achieved with TS that's great or any other possible > solutions would be nice too. > > Thanks. > > -- > 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. > -- 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.
