|
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: manesaj@xxxxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: using window functions > Date: Mon, 16 Mar 2009 23:58:25 -0400 > From: tgl@xxxxxxxxxxxxx > > Daniel Manesajian <manesaj@xxxxxxxxxxx> 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. Check it out. |
