Search Postgresql Archives

Re: Potentially annoying question about date ranges (part 2)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you very much.

Sorry to be unclear, they are time stamped, and I wondered if someone
could give me ssome advise how I do this aggregation. In particular do
I not know how to write such a scalar function.

Anything re-usable lying around as examples somewhere?

el

on 10/4/06 9:46 PM Guy Rouillier said the following:
> Eberhard Lisse wrote:
>> I receive payments, but not every day (or even every week),
>> and I would like see how much I receive per week and/or per month. I
>> also need to compare different years. 
>>
>> I also would like to see what the (accumulated) sum of the payments
>> is at the end of a given week, month. 
> 
> Timestamp each transaction, then use a GROUP BY clause to aggregate the
> numbers however you wish.  If the available date field extractions are
> not sufficient, write a scalar function of your own to accomplish what
> you need.
> 

-- 
If you want to email me, replace nospam with el


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux