I would like to add one day to query date, then get all the data greater than today.
Fields:
valid_to
Table:
Post
Select * from posts where valid_to + 1 > Now()
>Solution :
The Postgres SQL you want here is:
SELECT * FROM posts WHERE valid_to + interval '1' day > NOW();
As for the logic, it is not clear this is the query you need without seeing some sample data.