Range type support with CDC trigger

[tamis-laan]

Is your feature request related to a problem? Please describe. I'm working with event objects that have an start and end date time. Support for the range type as seen in postgresql would be very useful.

Describe the solution you'd like I would like to see the range type implemented as in postgresql. For an example see the following video:

https://www.youtube.com/watch?v=eG_9lZrrbEY

I'd also like to see this connected to CDC where we would have an inrange event and a outrange event for when the range is "in range" and "out of range" respectively. This would allow for applications that have time sensitive data.

Describe alternatives you've considered Right now the only way to deal with this issue is to use an external process that polls the start and stop values:

SELECT * FROM MyTable
WHERE current_timestamp >= start AND current_timestamp <= stop;

Jira issue: CRDB-41117

[blathers-crl[bot]]

Hello, I am Blathers. I am here to help you get the issue triaged.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/cdc (found keywords: CDC)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

[blathers-crl[bot]]

cc @cockroachdb/cdc

[rharding6373]

Thanks for the suggestion. We don't have plans to implement this in our current roadmap.