From: chester c young <chestercyoung@yahoo.com>
To: Christopher Crews <isephoenix@yahoo.com>
Cc: sql pgsql <pgsql-sql@postgresql.org>
Subject: Re: Date and filling issues
Date: Thu, 20 Mar 2008 16:02:02 -0700 (PDT)
Message-ID: <158249.65933.qm@web54302.mail.re2.yahoo.com> (raw)
In-Reply-To: <687096.56737.qm@web52202.mail.re2.yahoo.com>
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chestercyoung@yahoo.com, isephoenix@yahoo.com
Subject: Re: Date and filling issues
In-Reply-To: <158249.65933.qm@web54302.mail.re2.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox