Ambiguous return message while creating a new node ($$ CREATE)

[RC-002]

Creating a new graph with the query "SELECT create_graph('demo_graph');" returns - "(1 row)" which assures me that the graph is created.

This is not consistent when I create a new node in the graph with the query "SELECT * FROM cypher('demo_graph', $$ CREATE (n:Person {name : "james", bornIn : "US"}) $$) AS (a agtype);" which returns "(0 rows)". This is ambiguous to me as an end-user whether the node is actually created or not.

To check whether the query was executed successfully or not, I searched for the inserted record with the query "SELECT * FROM cypher('demo_graph', $$ MATCH (v) RETURN v $$) as (v agtype);" . This returns the result set along with the newly added node. This shows me that the node was created successfully but the return message displays "(0 rows)".

[MatheusFarias03]

Hello @RC-002 ! From reading the CREATE section on the Apache AGE Documentation: https://age.apache.org/age-manual/master/clauses/create.html
You can return a newly created node by typing the following command:

SELECT * 
FROM cypher('graph_name', $$
    CREATE (a {name: 'Andres')
    RETURN a
$$) as (a agtype);

so then it will return:

a
-----
{id: 0; label: ‘’; properties: {name: ‘Andres’}}::vertex
-----
(1 row)

[jrgemignani]

create_graph() is a function to create a new graph and it returns void - 0. It is not the same as the cypher() function that can return any number of results, or none at all.

Additionally, as @MatheusFarias03 stated, you can have it return a result if necessary.

[RC-002]

Thank you for the clarification.