Re: searching array

Alright, what about with ANY?

--- Joe Conway <mail(at)joeconway(dot)com> wrote:

> Matthew Peter wrote:
> > Shouldn't >= also return Carols records since she
> > contains records GREATER THAN 10000? This is the
> > problem I'm having, there's no errors, just no
> records
> > matching the > (gt) part. Only exact matches.
>
> Look again at your query:
>
> SELECT * FROM sal_emp WHERE 10000 >= ALL
> (pay_by_quarter);
>
> You are asking for matches where 10000 is greater
> than or equal to all
> the elements in the array. In Carol's case 10000 is
> less than all the
> elements -- hence no match.
>
> Joe
>

__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/