On Sep 17, 5:05 pm, blumenkraft <vohs...@gmail.com> wrote: > Did you mean or(|) instead of and(&)?
Yes, sorry. > I need SQL UNION for efficiency reasons (using UNION instead of SQL > generated by > models.Advertisement.objects.filter( Q(company__name__search="test") | > Q(contact__phone__istartswith="8495") is 60x faster in my case) Then you'll need to use SQL. There's no way to do UNION in Django's ORM. An alternative is just to concatenate the two querysets: union = list(x) + list(y) -- DR. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
