=> select to_char(date_trunc('week', '2007-7-6'::date)::date + i,
                  'YYYY-mm-dd(Day)')
     from generate_series(0, 4) as g(i);
        to_char
-----------------------
 2007-07-02(Monday   )
 2007-07-03(Tuesday  )
 2007-07-04(Wednesday)
 2007-07-05(Thursday )
 2007-07-06(Friday   )
(5 rows)