Re: Wrong rows selected with view - Mailing list pgsql-general

From Tom Lane
Subject Re: Wrong rows selected with view
Date
Msg-id 6151.1132156401@sss.pgh.pa.us
Whole thread Raw
In response to Re: Wrong rows selected with view  (Bill Moseley <moseley@hank.org>)
Responses Re: Wrong rows selected with view
List pgsql-general
Bill Moseley <moseley@hank.org> writes:
> The first plan below returns the correct number of rows, the second plan does
> not.  These are after I did the reindex, btw.

Bizarre.  What are the datatypes of the columns being joined on?  If
they're string types, what's your database locale and encoding?

            regards, tom lane

pgsql-general by date:

Previous
From: Bill Moseley
Date:
Subject: Re: Wrong rows selected with view
Next
From: Bill Moseley
Date:
Subject: Re: Wrong rows selected with view