Re: [BUGS] BUG #6440: Window function in WHERE evaluated after agregate

2012-02-08 Thread Tom Lane
lo...@centrum.cz writes: > Window function in WHERE clause - as all other functions used in where - > should be evaluated before agregating takes place. Hmm? WHERE clauses are necessarily evaluated before aggregating; that's one of the main reasons why there's a difference between WHERE and HAVIN

[BUGS] BUG #6440: Window function in WHERE evaluated after agregate

2012-02-08 Thread logik
The following bug has been logged on the website: Bug reference: 6440 Logged by: Matyas Novak Email address: lo...@centrum.cz PostgreSQL version: 9.1.1 Operating system: Linux Description: Window function in WHERE clause - as all other functions used in where - should