[GitHub] [incubator-age] pdpotter commented on issue #45: unique properties / indexing

[GitBox <gi...@apache.org>]

pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1120878414

   Commit https://github.com/apache/incubator-age/commit/379983b0cefa92aff89eb8d641e05bb376c83862 includes some improvements which are relevant here:
   * agtype_access_operator is now immutable. This means it can be used directly to create unique indices. It is no longer necessary to create a separate immutable function. E.g.,
   
   ```
   CREATE UNIQUE INDEX person_id_idx ON mygraph.person(ag_catalog.agtype_access_operator(properties, '"id"'::agtype));
   ```
   
   * GIN indices are now used when filtering using WHERE clauses.
   
   Very nice work, thank you @JoshInnis!


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org