Hello list, <br /><br /> I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting
unexpectedresults when i query a specific view. <br /><br /> I can only reproduce the unexpected results with a very
specificset of tables, views, and relationships.<br /> The bad results are only manifest in 9.0 (beta and rc1). Version
8.4.4produces the expected results.<br /><br /> To sum up the issue ...<br /> 1. View register_orders_view contains
only1 row of data ...<br /><br /><font color="#009900"><i>ttype | ropnum | shop_name <br />
-------+--------+-----------<br/> or | 30129 | District1</i></font><br /><br /> 2. The query ...<br /><i><br
/><fontcolor="#009900">select * from register_orders_view where ttype='z'</font></i><br /><br /> ... should
returnno rows, however all rows are returned. <br /><br /><br /> Included are a buildDemo.sql file that will create the
necessarytables and views, and a runDemo.sql to demonstrate the query from #2 above. <br /><br /> If this is a valid
result,can someone please help me understand why?<br /> If this is a case of "not the best" architecture a explanation
wouldbe greatly apprecitated.<br /> Or if this is a bug with 9.0, what actions do I take to make the PostgreSQL team
awares?<br/><br /> nate<br /><br />