create table dates (date timestamp);
insert into dates values ('2005-08-08');
insert into dates values ('2005-08-09');
insert into dates values ('2005-08-10');
insert into dates values ('2005-08-11');
insert into dates values ('2005-08-12');
insert into dates values ('2005-08-13');
insert into dates values ('2005-08-14');
select date, extract (week from date) as week, extract (dow from date) as dow
from dates 
order by date;