Re: searching array

Matthew Peter <survivedsushi(at)yahoo(dot)com> writes:
> I was trying to search a array with a GTE to value and
> it doesn't work. Is this supported? Or am I missing
> something?

> SELECT * FROM sal_emp WHERE 10000 >= ALL (pay_by_quarter);

Define "doesn't work". Do you get an error --- if so, what exactly?
Do you get unexpected results --- if so, what? And what version of
Postgres are you using?

AFAIK it works in 7.4 and up:

regression=# select 100 >= all(array[1,2,4]);
?column?
----------
t
(1 row)

regression=# select 100 >= all(array[1,2,101]);
?column?
----------
f
(1 row)

regards, tom lane