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

2006-10-08 Thread Eberhard Lisse
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 Roui

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

2006-10-08 Thread Eberhard Lisse
Ok, Ok, Ok, Practical PostgreSQL, Chapter 5, date_part(), to_char() I got it :-)-O el on 10/8/06 9:43 AM Eberhard Lisse said the following: > 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. I

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

2006-10-04 Thread Guy Rouillier
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 wee

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

2006-10-04 Thread Eberhard Lisse
I have a similar question, 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, mont