You can do the same trick with django:
Entry.objects.extra(select={'foo_upper': 'upper(foo)'},
order_by=['foo_upper'])
On Wed, Feb 11, 2009 at 7:20 PM, jeffhg58 <jeffh...@comcast.net> wrote:
>
> I currently have a field which has upper and lower case characters. Is
> there a way for the django api to ignore case using the order_by. In
> postgresql sql I was able to convert the field to upper case when
> doing the sort and the results are what I expected.
>
> Thanks,
> Jeff
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
