"lily li" <l...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs