There's another query I want to do that I can't seem to wrap my head
around at the moment:
Say I have a model where Things have Properties each of a particular
PropertyType. So
class Property(models.Model):
thing = models.ForeignKey(Thing)
property_type = models.ForeignKey(PropertyType)
value = models.CharField(...)
...
I want to find, for a given PropertyType, all the Things that are
lacking any Property of that type.
Like my previous question, in SQL I could do it with an EXCEPT:
SELECT id
FROM myapp_thing
EXCEPT
SELECT thing_id
FROM myapp_property
WHERE property_type_id = ...
How can I best do these sorts of EXCEPT queries with the database API?
James
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
