Query planner and variables with constraint_exclusion - Mailing list pgsql-novice

From Aleksej Trofimov
Subject Query planner and variables with constraint_exclusion
Date
Msg-id 4E969BD1.4010402@ruptela.lt
Whole thread Raw
Responses Re: Query planner and variables with constraint_exclusion  (Aleksej Trofimov <aleksej.trofimov@ruptela.lt>)
List pgsql-novice
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..


pgsql-novice by date:

Previous
From: "Dournaee, Blake"
Date:
Subject: Re: question on cross-data center replication
Next
From: Aleksej Trofimov
Date:
Subject: Re: Query planner and variables with constraint_exclusion