Re: Constraint exclusion for timestamp expression

2014-05-20 14:26 GMT+03:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Victor Yegorov <vyegorov(at)gmail(dot)com> 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