On Thu, Jan 11, 2007 at 20:07:29 +0100,
Marcus Engene <mengpg@engene.se> wrote:
> Hi list,
>
> I'd like to generate the latest year dynamically with generate_series.
> This select works day wise:
>
> 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?
Are you just trying to get a list off the first of the month for the current
month and the next 11 months after that? For that you want to get the first
of the current month and then add s.a * '1 month' to it for 0 to 11.
