Ok, it is Monday -:) Thanks Tom!
-----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Monday, August 03, 2009 11:44 AM To: Bill Reynolds Cc: [email protected] Subject: Re: [GENERAL] using generate_series to iterate through months "Bill Reynolds" <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
