Re: order_by Ignore case

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 wrote: > > I currently have a field which has upper and lower case characters. Is > there a way for the django api to ignore case usi

order_by Ignore case

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 --~--~-~--~~