On Mon, 2025-11-03 at 22:36 +0100, Florents Tselai wrote:
> 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.
You can easily implement this yourself...
Also, there already is something similar in the shape of 'yesterday'::timestamptz.
Moreover, a good percentage of the users would instead need ago(interval) -> timestamp.
So I'd say that the added value is marginal, and I personally find
current_timestamp - INTERVAL '1' DAY
more readable and more SQL standard compliant than
ago('1 day')
Yours,
Laurenz Albe
