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. 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
