X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 51E399DCA16
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 17 Feb 2006 17:07:29 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 51586-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 17 Feb 2006 17:07:30 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196])
	by postgresql.org (Postfix) with ESMTP id C972E9DC982
	for <pgsql-sql@postgresql.org>; Fri, 17 Feb 2006 17:07:26 -0400 (AST)
Received: by wproxy.gmail.com with SMTP id i12so229877wra
	for <pgsql-sql@postgresql.org>; Fri, 17 Feb 2006 13:07:28 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=MrdFV5+mLcOPX1Mgojb3ZV6XeWvJOYznOfHq0jggyKDy29Zly/lTELEmRp6ZQTwAoh6N5uyAW1uF5eUDo5J/n7PyACuNZ1+KlqFSALlQWtxSR9zaIBp9CbLAVBZ9KqWn3PmAw4Qcax7yhtkLTlHn/M8PmtwvF0xWXyWhv6v5brM=
Received: by 10.64.196.13 with SMTP id t13mr1265601qbf;
	Fri, 17 Feb 2006 13:07:28 -0800 (PST)
Received: by 10.65.206.4 with HTTP; Fri, 17 Feb 2006 13:07:28 -0800 (PST)
Message-ID: <2bffcc330602171307i4b0c523eveeb6e3e4ecf1f46f@mail.gmail.com>
Date: Fri, 17 Feb 2006 16:07:28 -0500
From: Henry Ortega <juandelacruz@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Given 02-01-2006 to 02-28-2006, output all days.
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_7532_8619010.1140210448280"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.946 required=5 tests=[HTML_10_20=0.945,
	HTML_MESSAGE=0.001]
X-Spam-Score: 0.946
X-Spam-Level: 
X-Archive-Number: 200602/217
X-Sequence-Number: 24227

------=_Part_7532_8619010.1140210448280
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Is there a real quick way to do a query that will show me all the dates
given a startdate and an end date?

Given: 02-01-2006 and 02-28-2006
it should give me:
02-01-2006
02-02-2006
...
...
02-27-2006
02-28-2006

Can this be done by a built-in function perhaps?

------=_Part_7532_8619010.1140210448280
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Is there a real quick way to do a query that will show me all the dates <br=
>given a startdate and an end date?<br><br>Given: 02-01-2006 and 02-28-2006=
<br>it should give me:<br>02-01-2006<br>02-02-2006<br>...<br>...<br>02-27-2=
006
<br>02-28-2006<br><br>Can this be done by a built-in function perhaps? <br>=
<br><br>

------=_Part_7532_8619010.1140210448280--