BUG #7552: where clause gets ignored on one of view fields - Mailing list pgsql-bugs

From andrei@tchijov.com
Subject BUG #7552: where clause gets ignored on one of view fields
Date
Msg-id E1TDkRZ-0002HW-GT@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7552: where clause gets ignored on one of view fields  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7552
Logged by:          Andrei Tchijov
Email address:      andrei@tchijov.com
PostgreSQL version: 9.2.0
Operating system:   Ubuntu 11.10
Description:        =


In a view (can provide source upon request) where condition on one of
columns gets ignored by select. No errors at all. Select runs as if the
condition is not present. Where conditions on other columns work as
expected.

The very same view functions as it should in 9.1 and 9.0.

pgsql-bugs by date:

Previous
From: te
Date:
Subject: Re: how to proccess record returning null
Next
From: "McGehee, Robert"
Date:
Subject: Incorrect Sort Using Index Scan