Re: Constraint exclusion for timestamp expression - Mailing list pgsql-general

From Tom Lane
Subject Re: Constraint exclusion for timestamp expression
Date
Msg-id 11651.1400585215@sss.pgh.pa.us
Whole thread Raw
In response to Constraint exclusion for timestamp expression  (Victor Yegorov <vyegorov@gmail.com>)
Responses Re: Constraint exclusion for timestamp expression  (Victor Yegorov <vyegorov@gmail.com>)
List pgsql-general
Victor Yegorov <vyegorov@gmail.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.

            regards, tom lane


pgsql-general by date:

Previous
From: Victor Yegorov
Date:
Subject: Constraint exclusion for timestamp expression
Next
From: Victor Yegorov
Date:
Subject: Re: Constraint exclusion for timestamp expression