-
Using Cypher in a CTE Expression
There are no restrictions to using Cypher with CTEs (Common Table Expressions ). Query: WITH graph_query as ( SELECT * FROM cypher ( 'graph_name' , $$ ... -
REMOVE
Terminal REMOVE clauses Remove a property The REMOVE clause is used to remove properties from vertex and edges. Terminal REMOVE clauses A REMOVE clause that is not followed ... -
User defined functions
Users may add custom functions to AGE. When using Cypher functions, all function calls with a Cypher query use the default namespace of: ag_catalog . However if a user wants to us... -
SKIP
Introduction Skip first three rows Return middle two rows Using an expression with SKIP to return a subset of the rows SKIP defines from which record to start including the r... -
Predicate Functions
Exists(Property) Exists(Path) Predicates are boolean functions that return true or false for a given set of input. They are most commonly used to filter out subgraphs in the WHE... -
Numeric Functions
rand abs ceil floor round sign rand rand() returns a random floating point number in the range from 0 (inclusive) to 1 (exclusive); i.e.[0,1). The numbers returned follow ... -
String Functions
replace split left right substring rTrim lTrim trim toLower toUpper reverse toString replace replace() returns a string in which all occurrences of a specified strin... -
Logarithmic Functions
e sqrt exp log log10 e e() returns the base of the natural logarithm, e. Syntax: e() Returns: An agtype float . Query SELECT * FROM cypher ( 'graph_name' , $$... -
Trigonometric Functions
degrees radians pi sin cos tan Cot asin acos atan atan2 degrees degrees() converts radians to degrees. Syntax: degrees(expression) Returns: An agtype float . ... -
LIMIT
Introduction Return a subset of the rows Using an expression with LIMIT to return a subset of the rows LIMIT constrains the number of records in the output. Introduction LIM...
