'How to fetch (Interval based) recently create/updated rows in postgres sql when no modified_date col is not present

The need is to fetch the recent updated (or) created rows in postgres sql within 15 minutes interval when there is no date_modified or timestamp related columns.

I know this is possible in oracle with below query (not exactly sure but possibility is there in oracle).

SELECT * FROM TAB AS OF TIMESTAMP ( SYSTIMESTAMP - INTERVAL '15' MINUTE )

Not sure how can be handled "AS OF TIMESTAMP" in postgres sql.

I would need this kind of approach to deal with postgres sql. My pipeline will run for every 15 mins and should fetch if any rows are present for further processing.

Input:

row1 <= created 1 min ago
row2 <= updated 3 mins ago 
row3 <= created 65 mins ago

Expected:

row1 <= created 1 min ago
row2 <= updated 3 mins ago
postgresql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions