-
Using Cypher in a Join expression
A Cypher query can be part of a JOIN clause. Developers Note Cypher queries using the CREATE , SET , REMOVE clauses cannot be used in sql queries with JOINs , as... -
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... -
Scalar Functions
id start_id end_id type properties head last length size startNode endNode timestamp toBoolean toFloat toInteger coalesce id id() returns the id of a vertex or e... -
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... -
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' , $$... -
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... -
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...