Re: searching array - Mailing list pgsql-general

From Matthew Peter
Subject Re: searching array
Date
Msg-id 20051017192819.3624.qmail@web35201.mail.mud.yahoo.com
Whole thread Raw
In response to Re: searching array  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-general
Let me also say that I'm retarded. No excuses from me.
I'm officially retarded.



--- Matthew Peter <survivedsushi@yahoo.com> wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>




__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: searching array
Next
From: Tom Lane
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase