Hi Pat, I'm on TS 2.x. Was wondering if there's a way to define an index with an LEFT INNER JOIN instead of the default OUTER join? Basically I'd like to index a model's db row IFF there is a corresponding join table row and that join table row must have a column that is a certain value. In regular sql, it'd be:
SELECT * FROM table1 LEFT INNER JOIN table2 ON table2.table1_id = table1.id WHERE table2.col1 IS NOT NULL; Thanks, Ngan -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
