Re: searching array

Matthew Peter <survivedsushi@yahoo.com> writes:
> Yes. I did read it wrong. I wanted to find all records
> that contained x where x >= 10000

Then flip it around:

    contain x where 10000 <= x

    10000 <= ANY (array)

For syntactic reasons, there's no "ANY(array) >= x" construct,
so you have to write it this way.

            regards, tom lane