Hi list,
I'd like to generate the latest year dynamically with generate_series.
This select works day wise:
select date_trunc ('month', now())::date + s.a
from generate_series(0, 11) as s(a)
I tried this but it didn't work:
select date_trunc ('month', now())::date + interval s.a || ' months'
from generate_series(0, 11) as s(a)
This works but looks grotesque:
select distinct date_trunc ('month', now()::date + s.a)::date
from generate_series(0, 365) as s(a)
Is there a way to do this more elegantly?
Best regards,
Marcus
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
