Re: searching array - Mailing list pgsql-general

From Tom Lane
Subject Re: searching array
Date
Msg-id 10841.1129575745@sss.pgh.pa.us
Whole thread Raw
In response to Re: searching array  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: Re: searching array
Next
From: Matthew Peter
Date:
Subject: Re: searching array