You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2022/01/17 20:21:01 UTC

[GitHub] [incubator-age] bravius edited a comment on issue #161: Index is lost after using SET clause

bravius edited a comment on issue #161:
URL: https://github.com/apache/incubator-age/issues/161#issuecomment-1014861860


   @pdpotter - Hey bud, I was also looking for an indexing solution, so I just re-worked your function as a plpgsql function. It seems to work as expected now, throws error on duplicates. Thus, I don't think it was a bug, just the way the custom function was written:
   
   ```
   CREATE OR REPLACE FUNCTION get_id(properties agtype)
   RETURNS agtype
   AS
   $BODY$
   BEGIN
      return agtype_access_operator(properties, '"id"');
   END;
   $BODY$
   LANGUAGE plpgsql
   IMMUTABLE;
   ```


-- 
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