How to change boolean value in db after certain time?

Question

PostgreSQL

Hello everyone, I can’t figure out how to automatically change the value in the postgresql database, for example, change from true to false after 24 hours. I will be very grateful)

Answer 1

well, in general, there is a table with products and I planned to make such a functionality that will show information that this is a recently added product, and then automatically change its value after a certain time, well, the first thing that came to my mind was to do true, false)

Then the date of adding the product will be more than enough - then at the application level you can compare the current time and date of adding the product, and based on this, display this plate.
Well, either you can do something like this directly in the SQL query

SELECT id, (created_at > (current_timestamp - '1 day'::interval)) as "is_newly_added" FROM goods

Answer 2

99.99% sure you don't need it. For at least a hundred other users who have asked the same question here, it was solved in a different way.