Rod Taylor <rod.taylor@gmail.com> writes: > Should now/current_date be marked leakproof?
Since it has no argument, that should be moot.
Gah, you're right.
It seems to be because the below clause is timestamp without time zone:
WHERE current_date - interval '1 day'
This works as expected on 9.6 and head:
WHERE current_date::timestamp with time zone - interval '1 day' as ex2;
Of course, the first version without the cast does push through a barrier. So it's the timestamp_%_timestamptz operator functions that are missing the flag?
Attached is an example. It seems all 3 queries should be able to use the same type of plan.
