| From: | chester c young <chestercyoung(at)yahoo(dot)com> |
|---|---|
| To: | Christopher Crews <isephoenix(at)yahoo(dot)com> |
| Cc: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Date and filling issues |
| Date: | 2008-03-20 23:02:02 |
| Message-ID: | 158249.65933.qm@web54302.mail.re2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Tegebo | 2008-03-21 09:41:00 | Testing DDL |
| Previous Message | Erik Jones | 2008-03-20 22:28:18 | Dynamic sql and variable record types |