"Bill Reynolds" <Bill.Reynolds@xxxxxxxx> writes:
> Ok, I'm a bit stumped on getting my group by query to work which
> iterates through a number of months that basically a generate_series
> provides for me.
> ...
> select DATE('2008-05-01') + interval (s.a??? ' months') as Month_of
No, you're confusing a syntax that's meant to handle literal constants
with something that's appropriate for computation. What you want is
> select DATE('2008-05-01') + s.a * interval '1 month' as Month_of
that is, multiply the sequence output by a suitable interval constant.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
