Re: [BUGS] BUG #8396: Window function results differ when selecting from table and view, with where clause

2013-08-25 Thread Tom Lane
p...@weotta.com writes: > When I select from a view, the where clause in my select statement does not > restrict the rows processed by window functions referenced inside the view > definition. Thus, if window functions are involved, using a where clause > when selecting from a view and using a wher

[BUGS] BUG #8396: Window function results differ when selecting from table and view, with where clause

2013-08-24 Thread paul
The following bug has been logged on the website: Bug reference: 8396 Logged by: Paul M. Email address: p...@weotta.com PostgreSQL version: 9.3rc1 Operating system: Ubuntu Linux Description: When I select from a view, the where clause in my select statement does not r