2014-05-20 14:26 GMT+03:00 Tom Lane <[email protected]>: > Victor Yegorov <[email protected]> writes: > > How can I enforce pruning to kick in for the initial expressions? > > You already found out: use constants. The planner can't remove > partitions on the basis of clauses involving volatile, or even > stable, functions, because their results might be different at > runtime. >
Do you mean constants are the only way here? I.e. there is absolutely no way to use any of the "current date / timestamp" functions available? I've been trying to wrap current expressions into immutable functions, like `date_trunc`, without any luck. -- Victor Y. Yegorov
