Re: searching array - Mailing list pgsql-general

From Matthew Peter
Subject Re: searching array
Date
Msg-id 20051017190631.57611.qmail@web35212.mail.mud.yahoo.com
Whole thread Raw
In response to searching array  (Matthew Peter <survivedsushi@yahoo.com>)
Responses Re: searching array  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-general
Thanks. That syntax didn't look right to find values
gte 10000. But thanks everyone!



--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> 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
>





__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase
Next
From: Stephan Szabo
Date:
Subject: Re: searching array