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 are: "Data Types" chapter, "Date/Time Types" section "Functions and Operators" chapter, "Date/Time Functions and Operators" section "PL/pgSQL - SQL Procedural Language" chapter, especially the "Control Structures" section If you have trouble then please post what you've tried with an explanation of how you'd like it to work and a description of what actually happens. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
