id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29916	Add additional Postgres lookups to gain parity with supported range functions in Postgres	Peter J. Farrell	Peter J. Farrell	"Add support for following functions for Postgres range fields that are currently not supported in Django:

* isempty
* lower_inc
* upper_inc
* lower_inf
* upper_inf

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

Example usage:

{{{#!python
MyObject.objects.filter(date_range__upper_inf=True)  # for infinity
MyObject.objects.filter(date_range__upper_inf=False)  # for not infinity
}}}

Example code: [https://gist.github.com/peterfarrell/5c7b8d80319563813caba6320b568829]

These can all be implemented as new ORM lookups for the Postgres range type fields so the Django ORM can gain parity with functionality available in Postgres range fields."	New feature	assigned	contrib.postgres	2.1	Normal		lower_inf, upper_inf, isempty, lower_inc, upper_inc		Unreviewed	0	0	0	0	0	0