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