Re: Potentially annoying question about date ranges

[Frank Bax <fbax(at)sympatico(dot)ca>]

At 02:34 PM 9/30/06, Jan Danielsson wrote:
>    Is there a painfully obvious way (that I'm missing) to get all dates
> included in a query, using my current table design, so that my average
> will tell me how much I spend per day on average - including those days
> I don't spend anything. (I want to look at that number every morning,
> and if by the end of the day I haven't managed to keep my expenses under
> that number, I whip myself ten times and cry myself to sleep).


http://www.postgresql.org/docs/8.1/static/functions-srf.html