Hi,
I'm trying to get an advance taste of the window function feature that I believe is supposed to be in 8.4. I'm running 8.4devel snapshot (dated Jan-01 which seems kind of old) grabbed from the snapshot page on the postgresql website.
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"
Do I have to build from source to try window functions?
Thank you,
Daniel
Windows Live™: Keep your life in sync.
Check it out.