add TSTZRANGE postgres function to django.contrib.postgres.functions

[anthony sottile]

I believe something like

class TsTzRange(models.Func):
    function = "TSTZRANGE"
    output_field = DateTimeRangeField()

​https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-CONSTRUCT

[anthony sottile]

TSRANGE would be nice as well to get the non-timezone equivalent

[Sarah Boyce]

Thank you for the suggestion! When suggesting a new feature for Django, the feature should first be proposed and discussed with the community. To do that, please raise this on the ​new feature tracker where you'll receive feedback from the community.

I'll close the ticket for now, but if the community agrees with the proposal, please return to this ticket and reference the feature discussion so we can re-open it.

---

In terms of my opinion here, this isn't very much code for folks to add to their project if they need to use this function. I would like us to be clear on what functions should be added to django.contrib.postgres.functions and which shouldn't, in order to understand if this "fits". I would be interested in adding this if we agree this fits with a broader plan of what we should provide out the box.

[Anthony Sottile]

ah, figured this would be a fairly trivial addition to django.contrib.postgres.functions where a few other misc database functions already reside: ​https://github.com/django/django/blob/main/django/contrib/postgres/functions.py