[GitHub] [age-website] markgomer commented on issue #204: QUESTION: Node Constraints on Property

["markgomer (via GitHub)" <gi...@apache.org>]

markgomer commented on issue #204:
URL: https://github.com/apache/age-website/issues/204#issuecomment-1734163776

   @stugorf, you got it right, you have to explicitly cast to agtype arguments of functions that receive this kind of type.
   
   To make it a little more concise, you can set the search_path to ag_catalog after loading AGE on each session:
   
   ```
   LOAD 'age';
   SET search_path TO ag_catalog;
   ```
   
   This will allow you to keep the `ag_catalog` term out of your queries, making it a bit shorter:
   
   ```
   CREATE UNIQUE INDEX article_aid_idx ON news."Article"(agtype_access_operator(properties, '"aid"'::agtype));
   ```
   
   


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