Re: case insensitive "in" query

2010-12-24 Thread Christophe Pettus
On Dec 24, 2010, at 11:12 AM, Tim Saylor wrote: > Is there an alternative? This is probably a good case for doing a raw query. You can then do something along the lines of "WHERE lower(field) IN ('', '''...)". Depending on the data, creating a functional index on "lower(field)" might help pe

case insensitive "in" query

2010-12-24 Thread Tim Saylor
I have two lists of values and I need to filter a queryset to only rows in which a column's value is in one of these lists. The data is not case consistent, so if I were comparing the column to a single value I would use the "iexact" lookup type. Since I'm comparing to a list of values I'm using