Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 78077632B4B
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  8 Mar 2010 08:37:30 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 22944-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  8 Mar 2010 12:37:19 +0000 (UTC)
X-Greylist: delayed 00:06:37.88896 by SQLgrey-1.7.6
Received: from rediffmail.com (f5mail-237-209.rediffmail.com
 [202.137.237.209])
	by mail.postgresql.org (Postfix) with SMTP id 2784563223D
	for <pgsql-sql@postgresql.org>; Mon,  8 Mar 2010 08:37:18 -0400 (AST)
Received: (qmail 50570 invoked by uid 510); 8 Mar 2010 12:25:23 -0000
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=redf; d=rediffmail.com;
	b=rzWXBzmL8d9kxDl0Plo4BvKkmx3SfW8GMsEZgYfYw+ZEXW2J7XcqPVEJ/Cihc7GLCvyMcfQwZoBvWRb2qQkFoMs/nn4d78vaf1Zu6aYykIgNXgqWlUwuJc70k9yUO82BPJTrVNYabxCE3hiCtxFuj1131YMIiJRf9qv2pEnjmjw=
	;
X-CTCH-Spam: 
X-CTCH-VOD: 
X-CTCH-Flags: 
X-CTCH-RefID: 
Date: 8 Mar 2010 12:25:23 -0000
Message-ID: <20100308122523.50565.qmail@f5mail-237-209.rediffmail.com>
MIME-Version: 1.0
To: <pgsql-sql@postgresql.org>
Received: from unknown 164.164.79.12 by rediffmail.com via HTTP;
	08 Mar 2010 12:25:11 -0000
Subject: =?utf-8?B?bGlzdCBvZiBhbGwgbW9udGhz?=
From: "query" <search2006@rediffmail.com>
Content-Type: multipart/alternative;
	boundary="=_484d28810a276e7b5e461f0328ee205f"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.594 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_IMAGE_ONLY_08=1.787, HTML_MESSAGE=0.001,
	HTML_SHORT_LINK_IMG_1=0.001, MSGID_FROM_MTA_HEADER=0.803,
	UNPARSEABLE_RELAY=0.001
X-Spam-Level: **
X-Archive-Number: 201003/85
X-Sequence-Number: 33792

--=_484d28810a276e7b5e461f0328ee205f
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="UTF-8"

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 ?
 
--=_484d28810a276e7b5e461f0328ee205f
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="UTF-8"

Hi,<br><br>I want to display data for all days in a month even if no data e=
xists for that month. Some of the days in a month might not have any data a=
t all. With normal query, we can display days only if data exists.But I wan=
t to display rows for all days in a month with blank data for non-existing =
day in database.<br><br>How can this be achieved ?<br><span> </span><br><A =
HREF=3D"http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.=
com/signatureline.htm@Middle?" target=3D"_blank"><IMG SRC=3D"http://sigads.=
rediff.com/RealMedia/ads/adstream_nx.ads/www.rediffmail.com/signatureline.h=
tm@Middle"></A>
--=_484d28810a276e7b5e461f0328ee205f--