Week Sequence in Posgres

Here's how to generate a list of "week of" dates for the last 12 weeks using Postgres SQL: select date_trunc('week', current_date)::date - s.t as "weekOf" from generate_series(0, 7*12, 7) as s(t) order by "weekOf" asc; Result:

• 5/30/2011
• 6/6/2011
• 6/13/2011
• 6/20/2011
• 6/27/2011
• 7/4/2011
• 7/11/2011
• 7/18/2011
• 7/25/2011
• 8/1/2011
• 8/8/2011
• 8/15/2011
• 8/22/2011