Re: array weirdity - Mailing list pgsql-general

From Richard Huxton
Subject Re: array weirdity
Date
Msg-id 4A9FC39B.40001@archonet.com
Whole thread Raw
In response to array weirdity  (Sim Zacks <sim@compulab.co.il>)
List 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

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: array weirdity
Next
From: Michael Glaesemann
Date:
Subject: Re: array weirdity