how do I create partition based on modulus of an id? something like this:
create table my_table(id bigint)
partition by value (modulus(id,1000));
create table my_table_0
partition of my_table
for values in (0);
--- from 0-999
create table my_table_999
partition of my_table
for values in (999);
...how can I do this?