|
|
|
|
|
|
by eastern
3304 days ago
|
|
|
Actually using generate_series makes little sense. Why should one repeatedly calculate data that will never change. I have this table: CREATE TABLE all_dates (
date_stamp date NOT NULL,
is_month_end boolean,
is_year_end boolean,
is_week_end boolean,
is_quarter_end boolean,
CONSTRAINT all_dates_pkey PRIMARY KEY (date_stamp)
) filled with data from 1st Jan 1980 to 31st Dec 2050, which is the range my application needs. It's a mere 22k rows and has a whole host of uses. |
|
|