I was storing as YAML. Using a comma separated list is fine with me though if it appropriately only returns records containing a value within the time range.
Thanks for the :multi tip I think it will do the trick. Going to give it a shot. Cheers, Jeff On Dec 7, 4:21 am, Pat Allan <[email protected]> wrote: > 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 > > 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.
