All, I have some data that could be a combination of around 30 values. Typical values could be 'TB', 'TF', 'D', 'U', '-D', 'OP', 'RM', or nil.
Ideally, I'd use the SET data type in PostgreSQL, but ActiveRecord doesn't appear to support[1] this. More specifically, I can run a migration on my development database, but db/schema.rb contains a comment about an unsupported data-type. I've considered creating 30 columns to model this, however I'm not convinced that's efficient. I've also thought about separating each value with a : and storing this - for example, ":TF:-D:" - whilst I can query for "WHERE foo LIKE '%:D:%'", that probably isn't indexable as it's a text search. Can anyone help me to come up with an efficient way to do this in Rails 3.0.10? Kind regards, Peter [1] http://ionrails.com/2010/06/16/set-data-type-mysql-activerecord/ -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.
