"lily li" <lil@sybase.com> writes:
> It looks like postgreSQl 8.4 does not allow window frame clause inside OVER
> clause.
What it allows is spelled out in the fine manual:
http://www.postgresql.org/docs/8.4/static/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS
Future versions of PG might support more, but this is as far as 8.4
is going.
regards, tom lane