Matthew Peter <survivedsushi@yahoo.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
