thanks for your responses my problem is with many-to-many relationships, not with foreign keys. that is, the scope of my problem is much bigger than nulls in foreign key fields :)
getting objects linked by foreign keys is much simpler than getting objects related through many-to-many associations because the latter case requires more than one row per object to be returned from the database server, and these rows have to be traversed on the middle tier side to build a list of dependent objects to be able to return them as QuerySet to the caller. i guess django does not do it currently. hopefully in later versions. konstantin On Mar 9, 11:44 am, "noelbk" <[EMAIL PROTECTED]> wrote: > select_related() does not include tables that can be NULL. That makes > it hard to do inner joins with django. search for the "DjSelect" > topic in this group. > > On Mar 9, 8:29 am, Atilla <[EMAIL PROTECTED]> wrote: > > > > > On 08/03/07, akonsu <[EMAIL PROTECTED]> wrote: > > > > hello, > > > > as the subject says, select_related() does not return many-to-many > > > relations. is this a feature or a bug? > > > > thanks > > > konstantin > > > From what I've seen select_related() always joins up the related > > tables and select their values. Can you provide an example where this > > fails ?- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
