Re: Potentially annoying question about date ranges

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Potentially annoying question about date ranges
Date: 2006-09-30 18:43:56
Message-ID: 5.2.1.1.0.20060930144209.04031cb0@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-09-30 19:16:56 Re: Potentially annoying question about date ranges
Previous Message Jan Danielsson 2006-09-30 18:34:05 Potentially annoying question about date ranges

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-09-30 19:16:56 Re: Potentially annoying question about date ranges
Previous Message Jan Danielsson 2006-09-30 18:34:05 Potentially annoying question about date ranges