1

I am trying to create a view that provides all quarter starts from a date dimension. Here it is:

CREATE OR REPLACE VIEW quarter_starts AS
SELECT min(day_number_in_epoch) AS day_num FROM date_dimension dd
GROUP BY dd.calendar_year_quarter;

And postgres gives the error:

ERROR:  cannot change name of view column "min" to "day_num"