Joshua Marsh wrote:
Does/Can the index track each element in the array, or does it track only the array as a whole?
Built in index support works on the array as a whole, not the individual elements.
How can I increase the speed of a query like: SELECT * FROM table WHERE 123 = ANY(array_of_ints); ?
See contrib/intarray.
Joe
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
