| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashesh Vashi | 2009-08-27 11:31:03 | Re: BUG #5015: MySQL migration wizard does not start |
| Previous Message | Nikola Ciprich | 2009-08-27 08:18:23 | BUG #5017: unsigned packages in RHEL4 8.3 packages |