On Mar 23, 11:23 pm, "Vinicius Mendes | meiocodigo.com" <vbmen...@gmail.com> wrote: > Ok. The code proposed by Tim Shaffer works and gives only one query. > But it makes use of subselects, what is heavy for the database. Take a > look at the generated SQL: > > 'SELECT `auth_user`.`id`, `auth_user`.`username`, > `auth_user`.`first_name`, `auth_user`.`last_name`, > `auth_user`.`email`, `auth_user`.`password`, `auth_user`.`is_staff`, > `auth_user`.`is_active`, `auth_user`.`is_superuser`, > `auth_user`.`last_login`, `auth_user`.`date_joined` FROM `auth_user` > WHERE NOT (`auth_user`.`id` IN (SELECT U0.`id` FROM `auth_user` U0 > WHERE U0.`first_name` = vinicius )) LIMIT 21' > > I was thinking of something like: > > 'SELECT `auth_user`.`id`, `auth_user`.`username`, > `auth_user`.`first_name`, `auth_user`.`last_name`, > `auth_user`.`email`, `auth_user`.`password`, `auth_user`.`is_staff`, > `auth_user`.`is_active`, `auth_user`.`is_superuser`, > `auth_user`.`last_login`, `auth_user`.`date_joined` FROM `auth_user` > WHERE NOT `auth_user`.`first_name` = vinicius LIMIT 21'
For this example, you can just use: >>> User.objects.exclude(first_name='vinicius') Matt. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@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.
