3 ms·
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
by eastern 9y 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.