Re: searching array

From: Matthew Peter <survivedsushi(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Joe Conway <mail(at)joeconway(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: searching array
Date: 2005-10-17 19:28:19
Message-ID: 20051017192819.3624.qmail@web35201.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Let me also say that I'm retarded. No excuses from me.
I'm officially retarded.

--- Matthew Peter <survivedsushi(at)yahoo(dot)com> wrote:

> Thanks. That syntax didn't look right to find values
> gte 10000. But thanks everyone!
>
>
>
> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> > Matthew Peter <survivedsushi(at)yahoo(dot)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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-17 19:31:31 Re: [pgsql-advocacy] Oracle buys Innobase
Previous Message Robert Bernier 2005-10-17 19:22:49 Re: Oracle buys Innobase