Using database values in django queryset

Question

Basically what i'm trying to accomplish is a query like this but using QuerySet:

SELECT value1, value2 FROM table WHERE value1 > value2

How do i do this? Thanks for your help.

Answer 1

You need to use the F() expression

In your example it would look like:

from django.db.models import F
Table.objects.filter(value1__gt=F('value2')).values('value1', 'value2')

Answer 2

Use F expressions to have a query field refer to another.

from django.db.models import F
Entry.objects.filter( n_comments__gt=F('n_pingbacks') )