generate_series with month intervals

Поиск
Список
Период
Сортировка
Искать
От
Marcus Engene
Тема
generate_series with month intervals
Дата
Msg-id
45A68AF1.6030202@engene.se
Список
Дерево обсуждения
generate_series with month intervals Marcus Engene <mengpg@engene.se>
Re: generate_series with month intervals Bruno Wolff III <bruno@wolff.to>
Re: generate_series with month intervals Tom Lane <tgl@sss.pgh.pa.us>
Re: generate_series with month intervals Marcus Engene <mengpg@engene.se>
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

В списке pgsql-general по дате отправления
От: Merlin Moncure
Дата:
Сообщение: Re: Trying to load MySQL data
От: Merlin Moncure
Дата:
Сообщение: pg_standby testing notes
FAQ