Thanks alot. It worked :)

On 21 дек, 06:56, Pat Allan <[email protected]> wrote:
> 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 
> > 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.

Reply via email to