array weirdity - Mailing list pgsql-general

From Sim Zacks
Subject array weirdity
Date
Msg-id 4A9FC250.2030500@compulab.co.il
Whole thread Raw
Responses Re: array weirdity
Re: array weirdity
List pgsql-general
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


select 1229 = any('{1220,0,0,1228,1229,1231,0,0,0}'::int[]) as result

result

-------

t




pgsql-general by date:

Previous
From: dennis jenkins
Date:
Subject: How do I use tsvector_update_trigger to index non-character columns?
Next
From: Richard Huxton
Date:
Subject: Re: array weirdity