Hi, I'm using globalize2 to translate some models in french and english. It stores the translations in a separate table, and each row has a locale column containing the string "fr" or "en". I would like to be able to filter my results so that I'm able to search only one language at a time.
I read everywhere that string attributes are automatically converted to integers so that sorting can work on those attributes... but if somehow I could know what the integer value of "en" and "fr" is, could I be able to filter by that column in my :with clause? I also tried indexing the locale column using something like this : has "CRC32(feature_translation.locale)", :type => :integer, :as => :t_locale so that the locale field is indexed as an integer, but since I'm using postgresql it gives me an error about the field not being in the group_by clause. Help or insights would be greatly appreciated, thanks! Pat --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
