On 4/28/20 1:58 PM, Taylor Sarrafian wrote:
Hi friends!
We tried to index an array function like this:
CREATE INDEX my_arr_index ON my_table USING GIN ( my_arr_func( my_col ) )
But the planner can’t seem to figure out how to use the index with any
query! It doesn’t work with any array oper
Hi friends!
We tried to index an array function like this:
CREATE INDEX my_arr_index ON my_table USING GIN ( my_arr_func( my_col ) )
But the planner can’t seem to figure out how to use the index with any query!
It doesn’t work with any array operators.
SELECT * FROM my_table WHERE ARRAY[ 1