Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group