OOPs! --- Richard Broersma Jr <rabroersma@xxxxxxxxx> wrote: > --- "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 S.synsetid = T.synsetid > WHERE W.lemma = 'scramble' > AND R.linked = 1 > AND T.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 > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
