ago(interval) → timestamptz
Florents Tselai <florents.tselai@gmail.com>
From: Florents Tselai <florents.tselai@gmail.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-11-03T21:36:43Z
Lists: pgsql-hackers
Attachments
- v1-0001-Add-ago-interval-function-to-subtract-interval-fr.patch (application/octet-stream)
Hi, I realize this will get some "you can easily implement this yourself” pushback, But I keep seeing and writing a lot of WHERE ts > now() - interval '1 day' expressions. Having $subject should help in such cases. We already have now, and age, so we might as well have ago too. Other systems also expose similar helpers. Cheers, Flo