Re: array weirdity

From: Richard Huxton <dev(at)archonet(dot)com>
To: Sim Zacks <sim(at)compulab(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: array weirdity
Date: 2009-09-03 13:24:43
Message-ID: 4A9FC39B.40001@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sim Zacks wrote:
> How can these both be true? Is there a way to see if a value is not in
> an array?
>
>
> select 1229 <> any('{1220,0,0,1228,1229,1231,0,0,0}'::int[]) as result
>
> result
> -------
> t

Not "any()", "all()" - it *is* different from some of the numbers there.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2009-09-03 13:41:09 Re: array weirdity
Previous Message Sim Zacks 2009-09-03 13:19:12 array weirdity