Skip site navigation (1) Skip section navigation (2)

BUG #5018: Window function alias

From: "Marko Tiikkaja" <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5018: Window function alias
Date: 2009-08-27 11:22:02
Message-ID: 200908271122.n7RBM2Cs083448@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5018
Logged by:          Marko Tiikkaja
Email address:      marko(dot)tiikkaja(at)cs(dot)helsinki(dot)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?

Responses

pgsql-bugs by date

Next:From: Ashesh VashiDate: 2009-08-27 11:31:03
Subject: Re: BUG #5015: MySQL migration wizard does not start
Previous:From: Nikola CiprichDate: 2009-08-27 08:18:23
Subject: BUG #5017: unsigned packages in RHEL4 8.3 packages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group