Apply bind variable to cypher about age

[pdpotter]

From #43 (comment):

The format $1 is the Postgres format for parameters and cannot be used in the cypher query. Parameters in the cypher query must take the format $parameter_name. When you want to pass parameters to a cypher query, you must add a third argument to the cypher query. This argument must be a Postgres parameter. So your query must look like:

SELECT * FROM cypher('testgraph', $$CREATE (v:Person {name: $var_name})$$, $1) as (a agtype);

When executing the query the value passed to $1 must be an agtype map, where the key is the variable name. NOTE: All parameters in the cypher query are passed in the map.

For more information, see the section Prepared Statements in the AGE Guide (PDF).

[kysmou]

Thank you for your response.
I will check it by referring to the manual again. Thank you so much.

[kysmou]

To test the prepared statement, I tested it by referring to the manual.
However, the following error occurs, but if there is something I am doing wrong, please tell me. This is the age 0.4.0 version.

PREPARE cypher_stored_procedure(agtype) AS
SELECT *
FROM cypher('test_graph', $$
MATCH (v:Person)
WHERE v.name = $name
RETURN v
$$, $1)
AS (v agtype);

execute cypher_prepared_statement('{"name":"affeee"}');
ERROR: prepared statement "cypher_prepared_statement" does not exist
STATEMENT: execute cypher_prepared_statement('{"name":"affeee"}');
prepared statement "cypher_prepared_statement" does not exist

[JoshInnis]

In the second example, the prepared statement is called "cypher_stored_procedure" and the execute is for the prepared statement "cypher_prepared_statement."