Re: Optimizing NOT IN plans / verify rewrite

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:

> DELETE FROM foo
>   where foo.b in (
>     select b from foo WHERE type = 'o'
>     except SELECT b FROM bar
>     except SELECT b FROM foo where type <> 'o');

Oops.  Maybe before I get excited I should try it with a query which
is actually logically equivalent.  :-(

-Kevin