Thanks Tom, I do have a self-contained test case which duplicates the problem. However, since there are data to be attached and there wasn't a way to attach in the bug reporting form, I wasn't sure how to proceed.
Would appreciate your assistance. Thanks again. On Wed, Sep 26, 2012 at 11:13 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > mtesf...@gmail.com writes: > > I had a problem with missing rows in a resultset when using WHERE .. IN > > after upgrading to 9.2.0. > > We'll need a self-contained test case to investigate that. The query > alone is of no help without table definitions and sample data sufficient > to reproduce the misbehavior. Since I gather that the table names in > the query are not even tables but views, what you've provided is even > more inadequate for investigation. > > You can find some advice about submitting useful bug reports at > https://wiki.postgresql.org/wiki/Guide_to_reporting_problems > > regards, tom lane >