DateRange__contains does not work as filter.

[henhuy]

Having a model containing django.contrib.postgres.fields.DateRangeField I cannot filter the range by date using "contains", BUT I can get one object using "contains".

Example (my original case, is different - but this should show the error as well):

import datetime as dt
from django import models
from django.contrib.postgres.fields import DateRangeField

class Period(models.Model):
    value = models.IntegerField()
    period = DateRangeField()

date = dt.date(2017, 1, 1)

# This works:
period = Period.objects.get(period__contains=date)

# This does not work:
period = Period.objects.filter(period__contains=date).first()

SQL-Query:
SELECT "period"."id", "period"."value", "period"."period" FROM "period" WHERE "period"."period" @> (2017-01-01)::date
SQL-Error (translated from german):
FEHLER: Cannot transform Typ integer into date

There should be ' around the date, then it would work:
SELECT "period"."id", "period"."value", "period"."period" FROM "period" WHERE "period"."period" @> ('2017-01-01')::date

Don't know why getworks instead...

[Mariusz Felisiak]

Thanks for this report, however I cannot reproduce this issue in Django 2.2, 3.0 or on master. Everything works for me.