Re: [ADMIN] Indexing array columns.

2005-11-21 Thread Joe Conway
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_

[ADMIN] Indexing array columns.

2005-11-21 Thread Joshua Marsh
I've been searching the manual looking for information about the effects of indexing an array column but haven't found any information as of yet.  Does anyone have any information on how the indexes work for arrayed columns?  Does/Can the index track each element in the array, or does it track