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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
