| 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:06:31 |
| Message-ID: | 20051017190631.57611.qmail@web35212.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Gibson (DB Administrator) | 2005-10-17 19:17:03 | Re: Planner regression in 8.0.x ? |
| Previous Message | Chris Travers | 2005-10-17 19:05:59 | Re: [GENERAL] Oracle buys Innobase |