Hi,
When I run one query on one partitioned table.
Select * from customer where opendate = (date_trunc('month', current_date)+'11 days'::interval)::date ;
This query will do that postgres will check all my partitions.
How can I do ?
Step 1 generate one sql that will be like "Select * from customer where opendate = '2016-11-01' ;
Step 2 :: Then run code from step1.
Any advice?
//Bill