On 6/25/07, Tim Tsai <[EMAIL PROTECTED]> wrote: ... > sqlite> select position_payrate, position_payrate - 20000 as diff, > abs(position_payrate - 20000) as adiff from positions order by adiff asc > limit 20; > 20000|0|0 ...
http://www.djangoproject.com/documentation/db-api/#extra-select-none-where-none-params-none-tables-none positions.objects.extra(select={'diff':'position_payrate - 20000', 'adiff':'abs(position_payrate - 20000)'}).order_by('adiff')[:20] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
