Hi Tom,
psql --version returns 8.4devel. I would in fact like to try a newer snapshot, but I'm not sure how to get one. The devel snapshot 'one-click-installer' link provided at postgresql.org gives a 2009-01-01 version with no options for anything newer or older. I was thinking my next step would be to build from source by grabbing the next daily snapshot. Is this the thing to do? Regards, Daniel > To: mane...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] using window functions > Date: Mon, 16 Mar 2009 23:58:25 -0400 > From: t...@sss.pgh.pa.us > > Daniel Manesajian <mane...@hotmail.com> writes: > > When I try a simple query "select avg(my_int) over (order by my_int rows > > unbounded preceding) order by 1;" I get an error: > > ERROR: syntax error at or near "over" > > You sure you're actually talking to the 8.4 server? Because that's > exactly what you'd get if you tried to feed the command to an older > release. > > You might in fact need a newer snapshot too. The main window functions > commit went in 2008-12-28 but I recall that there were some mop-up fixes > afterwards. At best a 1-Jan snapshot would be a bit unstable. > > regards, tom lane _________________________________________________________________ Windows Live™ Groups: Create an online spot for your favorite groups to meet. http://windowslive.com/online/groups?ocid=TXT_TAGLM_WL_groups_032009
