On Wed, Mar 30, 2005 at 16:45:43 -0700,
Mark Fox <[EMAIL PROTECTED]> wrote:
>
> What I want is SELECT statement that references no tables but returns
> the days in a given month. I'm now thinking that I might be able to
> come up with something using an IN clause and using EXTRACT, but
> haven't figured it out yet.
You can use the output of the suggested functions as input to
generate_series functions (new in 8.0) and add their output to the
start date of a month, to get a set of dates (as opposed to just a first
and last day of month).
---------------------------(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
