I am trying to create a partition for the last 30 days. Yet when I run this code:
create table Test_Older30day partition of Test for values from (current_timestamp + interval'-30 day') to (current_timestamp);
I get this error:
syntax error at or near "current_timestamp"
I am confused, what am I doing wrong here?
the table looks like this:
create table if not exists Test( source_name varchar, event_name varchar, service_data json, stamp timestamptz )partition by range(stamp);
data types match and I have used the partition by range on the date field.