Ok, it is Monday -:) Thanks Tom! -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Monday, August 03, 2009 11:44 AM To: Bill Reynolds Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: using generate_series to iterate through months "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
