Partition and Functions

[Leandro Guimarães <leo.guimaraes@xxxxxxxxx>]

Hi Everyone,

  I have a partitioned by period table scenario here where I need to execute a query with a function in where clause. 

  I'm not sure if this is the best approach to do that, but when I use the functions, it scans all the tables instead only the desired one. If I put the parameter hardcoded, it works fine. 

  Any idea how could I solve this? Follow my query example:

SELECT customer_id, 
       date_id, 
       kpi AS kpi_value 
FROM   schema1.table1 
WHERE  date_id >= To_char(( current_date - interval '30' day ) :: DATE,'YYYYMMDD')::INTEGER 

Thanks!

Leandro Guimarães