> 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.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to