Grant Maxwell <grant.maxwell@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
