list of all months - Mailing list pgsql-sql

From query
Subject list of all months
Date
Msg-id 20100308122523.50565.qmail@f5mail-237-209.rediffmail.com
Whole thread Raw
Responses Re: list of all months
Re: list of all months
Re: list of all months
Re: list of all months
List pgsql-sql
Hi,

I want to display data for all days in a month even if no data exists for that month. Some of the days in a month might not have any data at all. With normal query, we can display days only if data exists.But I want to display rows for all days in a month with blank data for non-existing day in database.

How can this be achieved ?

pgsql-sql by date:

Previous
From: dennis
Date:
Subject: Re: Help : insert a bytea data into new table
Next
From: Navanethan Muthusamy
Date:
Subject: Clarification With Money data type