Re: Lifting WHERE conditions out of inner select - Mailing list pgsql-general

--- "John D. Burger" <john@mitre.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 S1.synsetid = T.synsetid
     WHERE W.lemma = 'scramble'
       AND R.linked = 1
       AND R.pos='v'
  ORDER BY lemma;

Regards,
Richard Broersma Jr.