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
"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.
In response to
pgsql-sql by date
|Next:||From: Kenneth Gonsalves||Date: 2004-12-11 05:00:55|
|Subject: replacing mysql enum|
|Previous:||From: Stephan Szabo||Date: 2004-12-11 02:28:38|
|Subject: Re: Query is not using index when it should|