Zainab-Saad commented on issue #978: URL: https://github.com/apache/age/issues/978#issuecomment-1584106238
In AGE, only the rows returned from the cypher query will be displayed in the table (even if you made changes to graph entities in your cypher query) and hence you need to use the `RETURN` clause to see the changes made to the graph entities. For example, in both the UPDATE and DELETE examples, you need to RETURN the rows as : ``` SELECT * FROM cypher ( 'tmp', $$ MATCH (a:Part) WHERE a.part_num=~'3+' SET a.part_num='333' RETURN a $$) AS (a agtype) ; ``` and ``` SELECT * FROM cypher ( 'tmp', $$ MATCH (a:Part) WHERE a.part_num=~'3+' DELETE a RETURN a $$) AS (a 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
