pg生成日期序列

 原來pg生成日期序列這麼容易，我在sql server裡隻能寫遞歸來完成，囧

select generate_series from generate_series(to_date('2012-04-19','yyyy-mm-dd'),

                                                       to_date('2012-05-18', 'yyyy-mm-dd'),

                                                       '1 day' ::interval)