Re: ago(interval) → timestamptz

On 11/4/25 1:55 PM, Laurenz Albe wrote:
> 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')
>
now() - interval '1 day' is merely an example. In fact, we could use any
time. For example
now() - interval '10 day 5 hours 21 minutes'
This is beyond the scope of what yesterday() can support.

Therefore, I think this patch can be accepted. Make the user's operation
more convenient.

--
Quan Zongliang

> Yours,
> Laurenz Albe
>