Re: [SQL] Create Calendar

Muhyiddin A.M Hayat wrote: How to create Calendar using Function/View. For example i would like to display date 2004-12-01 to 2004-12-20. date -- 2004-12-01 2004-12-02 2004-12-03 2004-12-04 2004-12-05 .. .. 2004-12-20 -- Use in Postgres 7.4.x and earlie

Re: [SQL] Create Calendar

On Sat, Dec 11, 2004 at 03:26:33AM +0800, Muhyiddin A.M Hayat wrote: > How to create Calendar using Function/View. > For example i would like to display date 2004-12-01 to 2004-12-20. You could write a function that returns SETOF DATE. Some sections of the documentation you'll want to study ar

[SQL] Create Calendar

Dear All,   How to create Calendar using Function/View. For example i would like to display date 2004-12-01 to 2004-12-20.   date -- 2004-12-01 2004-12-02 2004-12-03 2004-12-04 2004-12-05 .. ..  2004-12-20