Re: Lifting WHERE conditions out of inner select

OOPs!
--- Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:

> --- "John D. Burger" <john(at)mitre(dot)org> 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
>