SHOW FUNCTIONS
| name | category | description | |
|---|---|---|---|
|
1 | "abs" | "Numeric" | "Returns the absolute value of an `INTEGER` or `FLOAT`." |
|
2 | "acos" | "Trigonometric" | "Returns the arccosine of a `FLOAT` in radians." |
|
3 | "all" | "Predicate" | "Returns true if the predicate holds for all elements in the given `LIST<ANY>`." |
|
4 | "any" | "Predicate" | "Returns true if the predicate holds for at least one element in the given `LIST<ANY>`." |
|
5 | "asin" | "Trigonometric" | "Returns the arcsine of a `FLOAT` in radians." |
|
6 | "atan" | "Trigonometric" | "Returns the arctangent of a `FLOAT` in radians." |
|
7 | "atan2" | "Trigonometric" | "Returns the arctangent2 of a set of coordinates in radians." |
|
8 | "avg" | "Aggregating" | "Returns the average of a set of `INTEGER`, `FLOAT` or `DURATION` values." |
|
9 | "btrim" | "String" | "Returns the given `STRING` with leading and trailing whitespace removed." |
|
10 | "btrim" | "String" | "Returns the given `STRING` with leading and trailing `trimCharacterString` characters removed." |
|
11 | "ceil" | "Numeric" | "Returns the smallest `FLOAT` that is greater than or equal to a number and equal to an `INTEGER`." |
|
12 | "char_length" | "Scalar" | "Returns the number of Unicode characters in a `STRING`." |
|
13 | "character_length" | "Scalar" | "Returns the number of Unicode characters in a `STRING`." |
|
14 | "coalesce" | "Scalar" | "Returns the first non-null value in a list of expressions." |
|
15 | "collect" | "Aggregating" | "Returns a list containing the values returned by an expression." |
|
16 | "cos" | "Trigonometric" | "Returns the cosine of a `FLOAT`." |
|
17 | "cot" | "Trigonometric" | "Returns the cotangent of a `FLOAT`." |
|
18 | "count" | "Aggregating" | "Returns the number of values or rows." |
|
19 | "date" | "Temporal" | "Creates a `DATE` instant." |
|
20 | "date.realtime" | "Temporal" | "Returns the current `DATE` instant using the realtime clock." |
|
21 | "date.statement" | "Temporal" | "Returns the current `DATE` instant using the statement clock." |
|
22 | "date.transaction" | "Temporal" | "Returns the current `DATE` instant using the transaction clock." |
|
23 | "date.truncate" | "Temporal" | "Truncates the given temporal value to a `DATE` instant using the specified unit." |
|
24 | "datetime" | "Temporal" | "Creates a `ZONED DATETIME` instant." |
|
25 | "datetime.fromepoch" | "Temporal" | "Creates a `ZONED DATETIME` given the seconds and nanoseconds since the start of the epoch." |
|
26 | "datetime.fromepochmillis" | "Temporal" | "Creates a `ZONED DATETIME` given the milliseconds since the start of the epoch." |
|
27 | "datetime.realtime" | "Temporal" | "Returns the current `ZONED DATETIME` instant using the realtime clock." |
|
28 | "datetime.statement" | "Temporal" | "Returns the current `ZONED DATETIME` instant using the statement clock." |
|
29 | "datetime.transaction" | "Temporal" | "Returns the current `ZONED DATETIME` instant using the transaction clock." |
|
30 | "datetime.truncate" | "Temporal" | "Truncates the given temporal value to a `ZONED DATETIME` instant using the specified unit." |
|
31 | "db.nameFromElementId" | "Database" | "Resolves the database name for the given element id" |
|
32 | "degrees" | "Trigonometric" | "Converts radians to degrees." |
|
33 | "duration" | "Temporal" | "Creates a `DURATION` value." |
|
34 | "duration.between" | "Temporal" | "Computes the `DURATION` between the `from` instant (inclusive) and the `to` instant (exclusive) in logical units." |
|
35 | "duration.inDays" | "Temporal" | "Computes the `DURATION` between the `from` instant (inclusive) and the `to` instant (exclusive) in days." |
|
36 | "duration.inMonths" | "Temporal" | "Computes the `DURATION` between the `from` instant (inclusive) and the `to` instant (exclusive) in months." |
|
37 | "duration.inSeconds" | "Temporal" | "Computes the `DURATION` between the `from` instant (inclusive) and the `to` instant (exclusive) in seconds." |
|
38 | "e" | "Logarithmic" | "Returns the base of the natural logarithm, e." |
|
39 | "elementId" | "Scalar" | "Returns the element id of a `NODE` or `RELATIONSHIP`." |
|
40 | "endNode" | "Scalar" | "Returns the end `NODE` of a `RELATIONSHIP`." |
|
41 | "exists" | "Predicate" | "Returns true if a match for the pattern exists in the graph." |
|
42 | "exp" | "Logarithmic" | "Returns e^n, where e is the base of the natural logarithm, and n is the value of the argument expression." |
|
43 | "file" | "Scalar" | "Returns the absolute path of the file that LOAD CSV is using." |
|
44 | "floor" | "Numeric" | "Returns the largest `FLOAT` that is less than or equal to a number and equal to an `INTEGER`." |
|
45 | "graph.byElementId" | "Graph" | "Returns the graph reference with the given element id. It is only supported in the `USE` clause, on composite databases." |
|
46 | "graph.byName" | "Graph" | "Returns the graph reference of the given name. It is only supported in the `USE` clause, on composite databases." |
|
47 | "graph.names" | "Graph" | "Lists the names of graphs in the current database." |
|
48 | "graph.propertiesByName" | "Graph" | "Returns the `MAP` of properties associated with a graph." |
|
49 | "haversin" | "Trigonometric" | "Returns half the versine of a number." |
|
50 | "head" | "Scalar" | "Returns the first element in a `LIST<ANY>`." |
|
51 | "id" | "Scalar" | "Returns the id of a `NODE` or `RELATIONSHIP`." |
|
52 | "isEmpty" | "Predicate" | "Checks whether a `STRING`, `MAP` or `LIST<ANY>` is empty." |
|
53 | "isNaN" | "Numeric" | "Returns whether the given `INTEGER` or `FLOAT` is NaN." |
|
54 | "keys" | "List" | "Returns a `LIST<STRING>` containing the `STRING` representations for all the property names of a `NODE`, `RELATIONSHIP` or `MAP`." |
|
55 | "labels" | "List" | "Returns a `LIST<STRING>` containing the `STRING` representations for all the labels of a `NODE`." |
|
56 | "last" | "Scalar" | "Returns the last element in a `LIST<ANY>`." |
|
57 | "left" | "String" | "Returns a `STRING` containing the specified number (`INTEGER`) of leftmost characters in the given `STRING`." |
|
58 | "length" | "Scalar" | "Returns the length of a `PATH`." |
|
59 | "linenumber" | "Scalar" | "Returns the line number that LOAD CSV is currently using." |
|
60 | "localdatetime" | "Temporal" | "Creates a `LOCAL DATETIME` instant." |
|
61 | "localdatetime.realtime" | "Temporal" | "Returns the current `LOCAL DATETIME` instant using the realtime clock." |
|
62 | "localdatetime.statement" | "Temporal" | "Returns the current `LOCAL DATETIME` instant using the statement clock." |
|
63 | "localdatetime.transaction" | "Temporal" | "Returns the current `LOCAL DATETIME` instant using the transaction clock." |
|
64 | "localdatetime.truncate" | "Temporal" | "Truncates the given temporal value to a `LOCAL DATETIME` instant using the specified unit." |
|
65 | "localtime" | "Temporal" | "Creates a `LOCAL TIME` instant." |
|
66 | "localtime.realtime" | "Temporal" | "Returns the current `LOCAL TIME` instant using the realtime clock." |
|
67 | "localtime.statement" | "Temporal" | "Returns the current `LOCAL TIME` instant using the statement clock." |
|
68 | "localtime.transaction" | "Temporal" | "Returns the current `LOCAL TIME` instant using the transaction clock." |
|
69 | "localtime.truncate" | "Temporal" | "Truncates the given temporal value to a `LOCAL TIME` instant using the specified unit." |
|
70 | "log" | "Logarithmic" | "Returns the natural logarithm of a `FLOAT`." |
|
71 | "log10" | "Logarithmic" | "Returns the common logarithm (base 10) of a `FLOAT`." |
|
72 | "ltrim" | "String" | "Returns the given `STRING` with leading whitespace removed." |
|
73 | "ltrim" | "String" | "Returns the given `STRING` with leading `trimCharacterString` characters removed." |
|
74 | "max" | "Aggregating" | "Returns the maximum value in a set of values." |
|
75 | "min" | "Aggregating" | "Returns the minimum value in a set of values." |
|
76 | "nodes" | "List" | "Returns a `LIST<NODE>` containing all the `NODE` values in a `PATH`." |
|
77 | "none" | "Predicate" | "Returns true if the predicate holds for no element in the given `LIST<ANY>`." |
|
78 | "normalize" | "String" | "Normalize a `STRING`. The `STRING` will be normalized using the normal form 'NFC'." |
|
79 | "normalize" | "String" | "Normalize a `STRING`. The `STRING` will be normalized according to the specified normalization form." |
|
80 | "nullIf" | "Scalar" | "Returns null if the two given parameters are equivalent, otherwise returns the value of the first parameter." |
|
81 | "percentileCont" | "Aggregating" | "Returns the percentile of a value over a group using linear interpolation." |
|
82 | "percentileDisc" | "Aggregating" | "Returns the nearest `INTEGER` or `FLOAT` value to the given percentile over a group using a rounding method." |
|
83 | "pi" | "Trigonometric" | "Returns the mathematical constant pi." |
|
84 | "point" | "Spatial" | "Returns a 2D or 3D point object, given two or respectively three coordinate values in the Cartesian coordinate system or WGS 84 geographic coordinate system." |
|
85 | "point.distance" | "Spatial" | "Returns a `FLOAT` representing the geodesic distance between any two points in the same CRS." |
|
86 | "point.withinBBox" | "Spatial" | "Returns true if the provided point is within the bounding box defined by the two provided points." |
|
87 | "properties" | "Scalar" | "Returns a `MAP` containing all the properties of a `NODE`, `RELATIONSHIP` or `MAP`." |
|
88 | "radians" | "Trigonometric" | "Converts degrees to radians." |
|
89 | "rand" | "Numeric" | "Returns a random `FLOAT` in the range from 0 (inclusive) to 1 (exclusive)." |
|
90 | "randomUUID" | "Scalar" | "Generates a random UUID." |
|
91 | "range" | "List" | "Returns a `LIST<INTEGER>` comprising all `INTEGER` values within a specified range." |
|
92 | "range" | "List" | "Returns a `LIST<INTEGER>` comprising all `INTEGER` values within a specified range created with step length." |
|
93 | "reduce" | "List" | "Runs an expression against individual elements of a `LIST<ANY>`, storing the result of the expression in an accumulator." |
|
94 | "relationships" | "List" | "Returns a `LIST<RELATIONSHIP>` containing all the `RELATIONSHIP` values in a `PATH`." |
|
95 | "replace" | "String" | "Returns a `STRING` in which all occurrences of a specified search `STRING` in the given `STRING` have been replaced by another (specified) replacement `STRING`." |
|
96 | "reverse" | "String" | "Returns a `STRING` or `LIST<ANY>` in which the order of all characters or elements in the given `STRING` or `LIST<ANY>` have been reversed." |
|
97 | "right" | "String" | "Returns a `STRING` containing the specified number of rightmost characters in the given `STRING`." |
|
98 | "round" | "Numeric" | "Returns the value of a number rounded to the nearest `INTEGER`." |
|
99 | "round" | "Numeric" | "Returns the value of a number rounded to the specified precision using rounding mode HALF_UP." |
|
100 | "round" | "Numeric" | "Returns the value of a number rounded to the specified precision with the specified rounding mode." |
|
101 | "rtrim" | "String" | "Returns the given `STRING` with trailing whitespace removed." |
|
102 | "rtrim" | "String" | "Returns the given `STRING` with trailing `trimCharacterString` characters removed." |
|
103 | "sign" | "Numeric" | "Returns the signum of an `INTEGER` or `FLOAT`: 0 if the number is 0, -1 for any negative number, and 1 for any positive number." |
|
104 | "sin" | "Trigonometric" | "Returns the sine of a `FLOAT`." |
|
105 | "single" | "Predicate" | "Returns true if the predicate holds for exactly one of the elements in the given `LIST<ANY>`." |
|
106 | "size" | "Scalar" | "Returns the number of items in a `LIST<ANY>` or the number of Unicode characters in a `STRING`." |
|
107 | "split" | "String" | "Returns a `LIST<STRING>` resulting from the splitting of the given `STRING` around matches of the given delimiter(s)." |
|
108 | "sqrt" | "Logarithmic" | "Returns the square root of a `FLOAT`." |
|
109 | "startNode" | "Scalar" | "Returns the start `NODE` of a `RELATIONSHIP`." |
|
110 | "stdev" | "Aggregating" | "Returns the standard deviation for the given value over a group for a sample of a population." |
|
111 | "stdevp" | "Aggregating" | "Returns the standard deviation for the given value over a group for an entire population." |
|
112 | "substring" | "String" | "Returns a substring of the given `STRING`, beginning with a 0-based index start." |
|
113 | "substring" | "String" | "Returns a substring of a given `length` from the given `STRING`, beginning with a 0-based index start." |
|
114 | "sum" | "Aggregating" | "Returns the sum of a set of `INTEGER`, `FLOAT` or `DURATION` values" |
|
115 | "tail" | "List" | "Returns all but the first element in a `LIST<ANY>`." |
|
116 | "tan" | "Trigonometric" | "Returns the tangent of a `FLOAT`." |
|
117 | "time" | "Temporal" | "Creates a `ZONED TIME` instant." |
|
118 | "time.realtime" | "Temporal" | "Returns the current `ZONED TIME` instant using the realtime clock." |
|
119 | "time.statement" | "Temporal" | "Returns the current `ZONED TIME` instant using the statement clock." |
|
120 | "time.transaction" | "Temporal" | "Returns the current `ZONED TIME` instant using the transaction clock." |
|
121 | "time.truncate" | "Temporal" | "Truncates the given temporal value to a `ZONED TIME` instant using the specified unit." |
|
122 | "timestamp" | "Scalar" | "Returns the difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC" |
|
123 | "toBoolean" | "Scalar" | "Converts a `BOOLEAN`, `STRING` or `INTEGER` value to a `BOOLEAN` value. For `INTEGER` values, 0 is defined to be false and any other `INTEGER` is defined to be true." |
|
124 | "toBooleanList" | "List" | "Converts a `LIST<ANY>` of values to a `LIST<BOOLEAN>` values. If any values are not convertible to `BOOLEAN` they will be null in the `LIST<BOOLEAN>` returned." |
|
125 | "toBooleanOrNull" | "Scalar" | "Converts a value to a `BOOLEAN` value, or null if the value cannot be converted." |
|
126 | "toFloat" | "Scalar" | "Converts a `STRING`, `INTEGER` or `FLOAT` value to a `FLOAT` value." |
|
127 | "toFloatList" | "List" | "Converts a `LIST<ANY>` to a `LIST<FLOAT>` values. If any values are not convertible to `FLOAT` they will be null in the `LIST<FLOAT>` returned." |
|
128 | "toFloatOrNull" | "Scalar" | "Converts a value to a `FLOAT` value, or null if the value cannot be converted." |
|
129 | "toInteger" | "Scalar" | "Converts a `BOOLEAN`, `STRING`, `INTEGER` or `FLOAT` value to an `INTEGER` value. For `BOOLEAN` values, true is defined to be 1 and false is defined to be 0." |
|
130 | "toIntegerList" | "List" | "Converts a `LIST<ANY>` to a `LIST<INTEGER>` values. If any values are not convertible to `INTEGER` they will be null in the `LIST<INTEGER>` returned." |
|
131 | "toIntegerOrNull" | "Scalar" | "Converts a value to an `INTEGER` value, or null if the value cannot be converted." |
|
132 | "toLower" | "String" | "Returns the given `STRING` in lowercase." |
|
133 | "toString" | "String" | "Converts an `INTEGER`, `FLOAT`, `BOOLEAN`, `POINT` or temporal type (i.e. `DATE`, `ZONED TIME`, `LOCAL TIME`, `ZONED DATETIME`, `LOCAL DATETIME` or `DURATION`) value to a `STRING`." |
|
134 | "toStringList" | "List" | "Converts a `LIST<ANY>` to a `LIST<STRING>` values. If any values are not convertible to `STRING` they will be null in the `LIST<STRING>` returned." |
|
135 | "toStringOrNull" | "String" | "Converts an `INTEGER`, `FLOAT`, `BOOLEAN`, `POINT` or temporal type (i.e. `DATE`, `ZONED TIME`, `LOCAL TIME`, `ZONED DATETIME`, `LOCAL DATETIME` or `DURATION`) value to a `STRING`, or null if the value cannot be converted." |
|
136 | "toUpper" | "String" | "Returns the given `STRING` in uppercase." |
|
137 | "trim" | "String" | "Returns the given `STRING` with leading and trailing whitespace removed." |
|
138 | "trim" | "String" | "Returns the given `STRING` with leading and/or trailing `trimCharacterString` removed." |
|
139 | "type" | "Scalar" | "Returns a `STRING` representation of the `RELATIONSHIP` type." |
|
140 | "valueType" | "Scalar" | "Returns a `STRING` representation of the most precise value type that the given expression evaluates to." |
|
141 | "vector.similarity.cosine" | "Vector" | "Returns a `FLOAT` representing the similarity between the argument vectors based on their cosine." |
|
142 | "vector.similarity.euclidean" | "Vector" | "Returns a `FLOAT` representing the similarity between the argument vectors based on their Euclidean distance." |
Started streaming 142 records after 25 ms and completed after 27 ms.
MATCH (person:Person) MERGE (location:Location {name: person.bornIn}) RETURN person.name, person.bornIn, location
-
Graph
-
Table
-
Text
-
Code
| person.name | person.bornIn | location | |
|---|---|---|---|
|
1 | "Charlie Sheen" | "New York" |
{
"identity": 16,
"labels": [
"Location"
],
"properties": {
"name": "New York"
},
"elementId": "4:f663624a-7b1b-4d10-97ec-097f40d46de6:16"
}
|
|
2 | "Martin Sheen" | "Ohio" |
{
"identity": 17,
"labels": [
"Location"
],
"properties": {
|
扫一扫
1360
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
