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