--- "John D. Burger" <john@xxxxxxxxx> wrote: > My question is, should the planner have figured this out, and we're > just losing out because we're stuck in 7.4? Or is there some subtle > difference in semantics I'm missing? The select results were the > same in both cases, but I'm willing to believe that's an accident of > our data. I don't know if this helps. SELECT lemma FROM word AS W INNER JOIN sense AS S ON W.wordid = S.wordid INNER JOIN semlinkref AS R ON R.synset1id = S.synsetid AND R.synset2id = S.synsetid INNER JOIN synset AS T ON S1.synsetid = T.synsetid WHERE W.lemma = 'scramble' AND R.linked = 1 AND R.pos='v' ORDER BY lemma; Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq