Re: using window functions

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(at)hotmail(dot)com
> CC: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] using window functions
> Date: Mon, 16 Mar 2009 23:58:25 -0400
> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
>
> Daniel Manesajian <manesaj(at)hotmail(dot)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