On Sunday, July 15, 2018, Anto Aravinth <anto(dot)aravinth(dot)cse(at)gmail(dot)com> wrote:
>
> I'm not sure, how to get started with this. Read about NOTIFY:
> https://www.postgresql.org/docs/current/static/sql-notify.html
>
>
> Not sure that fits my use case, thanks for your help in this.
>
It doesn't. You need to record time stamps for the relevant events and use
them to decide what is new and what is old.
David J.