Django Postgresql DateRange / DateTimeRange upper_inf and lower_inf functions

postgres_lookups.py

from django.db.models.lookups import Lookup


class DateRangeLowerInf(Lookup):
    """
     Use like:

     `MyObject.objects.filter(date_range__lower_inf=True)` for infinity
     `MyObject.objects.filter(date_range__lower_inf=False)` for not infinity
    """
    lookup_name = 'lower_inf'
    prepare_rhs = False

    def as_sql(self, compiler, connection):
        sql, params = compiler.compile(self.lhs)
        if self.rhs:
            return "upper_inf(%s)" % sql, params
        else:
            return "upper_inf(%s) IS FALSE" % sql, params


class DateRangeUpperInf(Lookup):
    """
     Use like:
     
     `MyObject.objects.filter(date_range__upper_inf=True)` for infinity
     `MyObject.objects.filter(date_range__upper_inf=False)` for not infinity
    """
    lookup_name = 'upper_inf'
    prepare_rhs = False

    def as_sql(self, compiler, connection):
        sql, params = compiler.compile(self.lhs)
        if self.rhs:
            return "upper_inf(%s)" % sql, params
        else:
            return "upper_inf(%s) IS FALSE" % sql, params

Additional functions that need to be implemented:

• isempty
• lower_inc
• upper_inc

https://www.postgresql.org/docs/9.3/static/functions-range.html