Grant Maxwell <grant.maxwell@maxan.com.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