andrew klassen <aptklassen(at)yahoo(dot)com> writes:
> Is there any alternative to what am I currently doing other than creating a row for
> each array element,
Since (I think) 8.2, you could create a GIN index on the array column
and then array overlap (&&) would be indexable. GIN has some
performance issues if the table is heavily updated, though.
regards, tom lane