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

From: Eberhard Lisse <nospam(at)lisse(dot)NA>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Potentially annoying question about date ranges (part 2)
Date: 2006-10-08 10:56:06
Message-ID: 4528D946.5090409@lisse.NA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2006-10-08 11:57:15 Re: exploiting features of pg to obtain polymorphism
Previous Message Karsten Hilbert 2006-10-08 10:42:31 Re: Storing images in PostgreSQL databases (again)

Browse pgsql-novice by date

  From Date Subject
Next Message jsmesegue 2006-10-09 10:46:44 ODBC Connection from Cognos Framework Manager to postgresql
Previous Message Eberhard Lisse 2006-10-08 07:43:38 Re: Potentially annoying question about date ranges (part 2)