Re: Query planner and variables with constraint_exclusion

On 10/13/2011 11:05 AM, Aleksej Trofimov wrote:
> Hello,
> I've got stuck with such a problem.. We are doing partitioning, but as
> I've
> read, query planner does not support variables in WHERE clause, so we
> can not use pgsql function with partitioning (where function parameters
> are passed into where clause of select). Is it possible to affect on
> planner behavior, that planner would be taking into account Variables?
> Or may be there are some other possibilities to use partitioning with
> variables in where clause? Such as dynamic sql, querying  directly
> partitioned table..
>
>
May be there is a way how to cast variable constant? Or it is only
possible using dynamic sql?