Re: searching array

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Peter 2005-10-17 19:02:40 Re: searching array
Previous Message Tom Lane 2005-10-17 18:56:03 Re: Planner regression in 8.0.x ?