[Info-ingres] ANY and ALL

[Roy Hann]

I have never been able to come up with a good example showing the
ANY/ALL construct is a clearer alternative to something else, nor 
an example of a query that can be done only using them.

A bit of googling has turned up a lot of unimaginative examples that
seem just to illustrate the syntax (plus a distressing number of
examples that flat-out don't do what they claim to do).

Rick van der Lans' _SQL Guide to Ingres_ manages some plausible examples
but nothing that isn't more easily and clearly done another way (IMO).

Can anyone suggest some interesting examples? 

I have a hazy intuition there may be some interesting queries that
depend on a subquery that returns no rows to ANY/ALL, but I can't bring
one into focus...

Roy