Re: searching array

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