>> > SELECT * from content where 42 = ANY (authors);
>> Postgres does have a way to do what you ask, though. It involves GiST
>> indexes and the operators from the contrib/intarray directory from the
>> Postgres source.
I have tried to use these indexes, and the performance was very good. It
can be faster (in fact much faster) than a join with an additional table,
because you don't have a join. The SQL array syntax is a pain, though.