The following bug has been logged online: Bug reference: 5018 Logged by: Marko Tiikkaja Email address: marko.tiikk...@cs.helsinki.fi PostgreSQL version: 8.4.0 Operating system: Linux Description: Window function alias Details:
I came across this: => SELECT lead(foo) OVER(ORDER BY foo) AS foo FROM (VALUES(0)) bar(foo); ERROR: window functions not allowed in window definition Changing the *column alias* to something else gives the expected answer. Is this really the desired behaviour? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
