Re: Help with Custom Manager and UNION query?

John, Thanks for the response. I don't think Q objects will work, since I need to do the fullsearch, and I'm pretty sure that has to go in .extra(). Also, I think Django would create a query with the joins, which are much slower than the UNION query. Somebody must have encountered this situation

Re: Help with Custom Manager and UNION query?

I'm not sure a Manager is what you want, what about Q(http:// docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with- q-objects) objects? I've used them before and I think it's about what you'd need. As for performance, not sure how they stack up On Nov 30, 2:45 pm, Info Cascade

Help with Custom Manager and UNION query?

Hi -- I've been programming with Django about a year, and really like it, but I've run into something that I can't quite solve on my own. I think someone else may be able to offer the answer, or at least a hint to send me in the right direction. I have two tables I want to search in