--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:

> At 12:40 PM 19-06-01 -0400, you wrote:
> >A customer converting from Oracle has a (horrible,
> >massive, badly performing) query that includes
> >something like this:
> >
> >select x from foo
> > where exists (select 1 from foo where x > 10
> > union
> > select 1 from foo where x < 10)
> >

<...>

>
> My SQL book isn't committing itself except to indicate that SQL-92

introduced a lot more "orthogonality" into subqueries (whatever that
means). (I thought it meant a state of having four interior right
angles..)

I always assumed it meant "a feeling akin to having hit your thumb
with a hammer, repeatedly".

db