Thanks. That syntax didn't look right to find values gte 10000. But thanks everyone! --- Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Matthew Peter <survivedsushi@xxxxxxxxx> 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
