Re: Partial indexes, PR help

2018-07-23 Thread Christophe Pettus
> On Jul 23, 2018, at 13:05, Christophe Pettus wrote: > > >> On Jul 23, 2018, at 12:20, Mads Jensen wrote: >> >> Q(published__gt=datetime.date(2017, 10, 1)) >> => >> "table"."published" > '2017-10-01'::timestamp; >> >> is unfortunate because it turns the function mutable, and the index can

Re: Partial indexes, PR help

2018-07-23 Thread Christophe Pettus
> On Jul 23, 2018, at 12:20, Mads Jensen wrote: > > Q(published__gt=datetime.date(2017, 10, 1)) > => > "table"."published" > '2017-10-01'::timestamp; > > is unfortunate because it turns the function mutable, and the index can > therefore not be created (exact error message can be seen in the

Partial indexes, PR help

2018-07-23 Thread Mads Jensen
Hi, I've opened a PR to add support for partial indexes in Django. It's on the right track, but I bumped into an issue that I need help with. On PostgreSQL, the cast that's introduced when doing something like: Q(published__gt=datetime.date(2017, 10, 1)) => "table"."published" > '2017-10-01':