Is it possible to reset a flag in PostgreSQL when time expires?

Question

PostgreSQL

I need to implement a counter so that after a certain point in time, after adding to the database, the record is set or, conversely, the flag is reset, that is, so that it can be tracked that a certain amount of time has passed since the record was added to the database. How to do it in PostgreSQL?

Answer 1

Why a flag? Keep track of when an entry was added or another desired date.