Re: Foreign Key query question

On Apr 11, 12:32 pm, Malcolm Tredinnick wrote: > That's definitely a small bug, then. I've opened ticket #10790 so that > it gets fixed eventually. Since it's not a functionality bug (the answer > is still correct), it will be fixed after 1.1 now, but we will fix it. I > understand why it's occ

Re: Foreign Key query question

On Apr 11, 3:11 am, Malcolm Tredinnick wrote: > Django's SQL is going exactly what you suspect and not using any outer > join here. Using a simplified version of the original two models: > >         class Student(models.Model): >            ... > >         class Message(models.Model): >        

Re: Foreign Key query question

On Mar 9, 3:21 am, Malcolm Tredinnick wrote: Hello, Malcolm. > > Again, the correct syntax would be: > > Message.objects.filter(student__isnull=True) Why ORM uses LEFT OUTER JOIN on this query ? Why not "... WHERE student_id IS NULL" ? --~--~-~--~~~---~--~~ You