I'm trying to use the SQL syntax in Agens Graph but I don't know to use it.
I tried the following query
SELECT * FROM MATCH result = ()-[]->() RETURN result;
Or
SELECT * FROM GRAPH MATCH result = ()-[]->() RETURN result;
but both gives me the following error
Syntax error at or near "MATCH"
You do not need to use SQL to wrap Cypher queries in AGViewer, instead just enter Cypher queries directly, for example:
SELECT * FROM cypher('graph_name', $$ MATCH result = ()-[]->() RETURN result $$) as (result agtype);
Can be simplified into the following in AGViewer:
MATCH result = ()-[]->() RETURN result;