Re: Grouping by date range - Mailing list pgsql-general

From Jeffrey Melloy
Subject Re: Grouping by date range
Date
Msg-id 3F42596D.3030503@visualdistortion.org
Whole thread Raw
In response to Re: Grouping by date range  (Alexander Litvinov <lan@ac-sw.com>)
Responses Re: Grouping by date range  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Alexander Litvinov wrote:

>if you need to handle large number of rows try to add columns with year and
>month, write triggers for filling this columns, make indexes and things
>should be fast.
>
>
Is this the only way to do it?  I was running into this problem, too.
It would be nice if the function indexes could handle things like
'date_part('month', <columname>)

Jeff


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: 3 way outer join dilemma
Next
From: Jan Wieck
Date:
Subject: Re: Simulating sequences