Postgresql Generate_Series to Create a Date Series

To generate a series of dates this is the optimal way:

1. SELECT t. ...
2. SELECT day::date FROM generate_series(timestamp '2004-03-07', '2004-08-16', '1 day') day; ...
3. SELECT generate_series(timestamp '2004-03-07', '2004-08-16', '1 day')::date AS day;