>
>Sorry,
>
>I made a major mistake. I somehow saw the period and period_version as the
>same.
>so, yes partitions are not pruned here. So my suggestion makes no sense.
Thats quite ok. I think my plan now is to have a table returning function that
executes a query dynamically. The query has a where caluse that is first
constructed.
Like this:
return query execute format('select d.x, d.y from %1$I.%1$I d where
d.period_version = any(' || quote_literal(_periode_version_array)
||'::text[])', register_in);
Regards Niels
