Bill Moseley <moseley@xxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq