Range of dates with infinite end are stored incorrectly in Postgres database about rails HOT 2 OPEN

Duplicate/Related to #51111?

from rails.

Duplicate/Related to #51111?

Not really, that is about how data is read back from the database and the change that unbounded values now comes back as nil where the before Rails 7.1 came back as Float::INFINITY, which I think is a change to the better.

This is about what how the data is going into the database. When a boundless end is sent to PostgreSQL it is sent as nil which in PostgreSQL will be stored as an excluded end, but if it is sent as infinity it will be stored as inclusive, and be returned as such.

It is possible that this could be considered a PostgreSQL problem too, because range = ["2024-01-01 00:00",infinity] could be the same as range = ["2024-01-01 00:00",], but the latter is saved as ["2024-01-01 00:00",).

From what I can tell, the value that goes into the database has to be modified from nil, to string infinity. But I could be wrong.

from rails.