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