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