jrgemignani commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1688509994
@vladiksun From what I've found, I believe so. Every time I debug the index - ``` psql-15.3-5432-pgsql=# CREATE INDEX profile_pet_btree_check_in_operator ON test_graph."profile" USING BTREE ( agtype_in_operator('["dog", "cat"]'::agtype, agtype_access_operator(VARIADIC ARRAY[_agtype_build_vertex(id, _label_name('16954'::oid, id), properties), '"pet"'::agtype]))); ``` the function that creates the index paths - `create_index_paths` - returns NULL partly because there isn't a support function defined for it. These functions are defined in `pg_proc `and assigned under the `prosupport` column. Assuming a support function would help here, we would need to research how to create one; the documentation is rather limited and so are the examples. It is possible there is another path that could create the index. However, this particular path is the one that matches but returns NULL due to the lack of a support function. Of course, this is all after changing the volatility flag to IMMUTABLE for `agtype_in_operator`. Right now, I have to turn my attention to the Apache release process for AGE for the next few weeks. So, I won't be able to give this issue as much time until after the releases are out. Hope this is helpful. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org