I want to create table which holds the data for transactions of one week, every day the oldest partition will be truncated, and the data of the new day will be entered in this partition.

the problem is that I couldn't find a way to create a partition on "week day" or on a function of the transaction date.

thanks for your help