Re: problem with array query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Grant Maxwell <grant(dot)maxwell(at)maxan(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with array query
Date: 2009-09-28 02:24:58
Message-ID: 12779.1254104698@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grant Maxwell <grant(dot)maxwell(at)maxan(dot)com(dot)au> writes:
> What I'm trying to do is find every record where "my name" is not in
> the array.
> So I tried <> ANY and also <> ALL and both returned an empty row set.

Maybe you have some nulls in the arrays? <> ALL works for me.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ricky Tompu Breaky 2009-09-28 04:51:40 Re: How should the first step of PostgreSQL implementation should be? (revised)
Previous Message Grant Maxwell 2009-09-28 02:15:46 Re: problem with array query