Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 253E92E0038 for ; Thu, 20 Mar 2008 20:02:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 96537-01 for ; Thu, 20 Mar 2008 20:01:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54302.mail.re2.yahoo.com (web54302.mail.re2.yahoo.com [206.190.49.112]) by postgresql.org (Postfix) with SMTP id 8BDD02E0035 for ; Thu, 20 Mar 2008 20:02:03 -0300 (ADT) Received: (qmail 67501 invoked by uid 60001); 20 Mar 2008 23:02:02 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=mj3NUHO5zBiJX9Pr4JKcIYgXufmAMj9v5vyYU+ox5gvMmiOrpalcH4vVFcJ8FY+Yx7SRTqnM36dqVRVBbGFheMHugGXDxK8itX5vTKRN7BcgcBgsPtvsmIf8Rfiq4duCAKipOnfjnH6d3JOEyoCV8+ET6p8DDcZY7wAFks+r+A4=; X-YMail-OSG: X7n7l3EVM1lIH_LaOZMWdaJ2B3oCG4MQ1hHsnvBm16y2.Kg50AS2CO.C1qj14IC.Jg-- Received: from [69.224.218.97] by web54302.mail.re2.yahoo.com via HTTP; Thu, 20 Mar 2008 16:02:02 PDT Date: Thu, 20 Mar 2008 16:02:02 -0700 (PDT) From: chester c young Subject: Re: Date and filling issues To: Christopher Crews Cc: sql pgsql In-Reply-To: <687096.56737.qm@web52202.mail.re2.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <158249.65933.qm@web54302.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/162 X-Sequence-Number: 30490 > > A sample of the current results data would be like > date sales > 2008-03-07 100.00 > 2007-03-10 150.00 > 2007-03-18 50.00 > > and what I'm trying to do is fill in the missing dates with sales > values of 0. what I do is have a table called days that is the left side of a left join. I'm not proud of this, but it works well. ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping