Hi Alexey This should be possible, albeit slightly fiddly - if you're using MySQL, you can do the following:
indexes "IF(email_verified = 1, email, '')", :as => :email I'm not sure if PostgreSQL has an IF function, so you may need to find something equivalent that does the same job - and I'm presuming here the two columns are email and email_verified - adapt as necessary. Cheers -- Pat On 21/12/2010, at 2:37 AM, Alexey Ilyichev wrote: > Hi! > > I need to build an index for users table and I want email to be > included only for these users who have verified their email. Is it > possible with thinking sphinx? > > -- > 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.
