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
36045	Add Support for PostgreSQL Infinity and -Infinity in Date/Time Fields	Kavin Bharathi		"**Proposed Feature:**

1. Add support for parsing PostgreSQL's infinity and -infinity values into Django models.
2. Represent infinity and -infinity using custom Python objects or constants (e.g., django.db.utils.Infinity and -Infinity).
3. Ensure seamless integration with Django's ORM for querying, inserting, and updating fields containing these values.
4. Provide a mechanism to serialize and deserialize these values (e.g., JSON serialization).

**Use Cases:**

1. Handling open-ended event durations.
2. Representing date ranges without a start or end boundary.
3. Supporting applications that already use these values in their PostgreSQL databases.

**Benefits:**

1. Enables Django developers to work with PostgreSQL databases more effectively.
2. Expands Django's compatibility with PostgreSQL's advanced features.

**Potential Challenges:**

1. Ensuring backward compatibility with existing applications.
2. Deciding on a Python representation for infinity that integrates well with Django's ORM and other Python libraries.

**References:**

[https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-DATETIME-SPECIAL-VALUES) PostgreSQL Documentation on Infinity]
"	New feature	closed	Database layer (models, ORM)	5.1	Normal	wontfix	postgres, infinity, datetime	Kavin Bharathi	Unreviewed	0	0	0	0	0	0