Re: Tabulate data incrementally - Mailing list pgsql-general

From Tom Lane
Subject Re: Tabulate data incrementally
Date
Msg-id 7428.1173367204@sss.pgh.pa.us
Whole thread Raw
In response to Tabulate data incrementally  (Omar Eljumaily <omar2@omnicode.com>)
Responses Re: Tabulate data incrementally  (Omar Eljumaily <omar2@omnicode.com>)
List pgsql-general
Omar Eljumaily <omar2@omnicode.com> writes:
> I want to tabulate time data on a weekly basis, but my data is entered
> on a daily basis.

Something involving GROUP BY date_trunc('week', _date) might work for
you, if your definition of week boundaries matches date_trunc's.
If not, you could probably make a custom function that breaks at the
boundaries you want.

            regards, tom lane

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: OT: Canadian Tax Database
Next
From: Richard Huxton
Date:
Subject: Re: Tabulate data incrementally