select *
from generate_series(date '2018-04-07', date '2018-04-14', interval '1 day') the day
where extract ('dow', the_day) = 1
I'm face many problems with this schema;
I should verify the boolean values.
I should extract the corresponding dates based to the values.
I decompose the period into different periods then run the query to fetch the products.
How can I enhance the query? or is there any proposition for the schema table to enhance it?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных