array weirdity

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: array weirdity
Date: 2009-09-03 13:19:12
Message-ID: 4A9FC250.2030500@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-09-03 13:24:43 Re: array weirdity
Previous Message dennis jenkins 2009-09-03 13:09:22 How do I use tsvector_update_trigger to index non-character columns?