Alright, what about with ANY? --- Joe Conway <mail@xxxxxxxxxxxxx> 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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
