Postgres Pro
Downloads
Home   >   mailing lists

Re: Need beginning and ending date value for a particular week in the year - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Need beginning and ending date value for a particular week in the year
Date
Msg-id 20090526221928.GL32650@alvh.no-ip.org
Whole thread Raw
In response to Re: Need beginning and ending date value for a particular week in the year  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
Tree view 
Alban Hertroys wrote:

> I recall using generate_series() and EXTRACT(week FROM ...) to populate
> the table in one pass for several years, but I don't have the exact
> incantation at hand now. I'd have to experiment a bit to get that back
> again, I don't have access to it anymore.

There's something similar in the Wiki:

http://wiki.postgresql.org/wiki/Date_and_Time_dimensions

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Brandon Metcalf
Date:
Subject: Re: quoting values magic
Next
From: zxo102 ouyang
Date:
Subject: How to speed up the first-time-searching in pgsql?