ago(interval) → timestamptz - Mailing list pgsql-hackers

From Florents Tselai
Subject ago(interval) → timestamptz
Date
Msg-id CA+v5N42fj6LtZxWJEsjPTRPqDceGLw+KrneeXXiH8_KduNV9qQ@mail.gmail.com
Whole thread Raw
Responses Re: ago(interval) → timestamptz
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Rishu Bagga
Date:
Subject: Re: [PATCH] Write Notifications Through WAL
Next
From: "Joel Jacobson"
Date:
Subject: Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue